On Mon, Sep 12, 2005 at 08:09:38AM +1000, Richard wrote: > > How are you getting the data from the database ?
> Same as you. I just took your routine, duplicated it, and did the following: Richard, do be aware that the v_emr_journal view is neither complete nor particularly suited to your objective. - It only includes narrative data and a few pieces here and there. - It is written with a particular way of displaying data in mind. IOW, if you are using the data from v_emr_journal you will likely miss out on some details - which may be fine. > 1) At top of the routine set up the html code for the <head>, etc section > 2) Used your data query in the routine and for each day put in a table > definition in html - putting the query results into the appropriate columns > 3)At end of routine put in all the close html tags eg </body> etc To do it properly one would need to - for an encounter (list) and episode (list) - retrieve list of relevant clin_root_items from v_pat_items - walk through the relevant items - retrieve data on each - hand the data to an HTML formatter depending on src_table - concatenate and frame the result Now, simple, if you send me HTML templates for how you want each clinical item (progress notes, vaccinations, family history, etc etc) to be rendered I will take care of the rest. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
