[Gnumed-devel] Report generator query for current patient medication and lab results

[Jim Busser]

Does the GNUmed / Postgres code specify a handle for the current patient and 
can a query be provided that could do the following


For the current patient

        select dosages of warfarin (INN B01AA03) and dates used
                where the dates have been within the most recent 16 weeks

        select also the values for the INR lab test LOINC = "34714-6"
                where the dates have been within the most recent 16 weeks

fields of interest: patient name, dob, sex, date/time, dosage, INR

idea is to eventually gnuplot them however not sure how easy or had to 
designate (from the report generator) the axes and the columns

There is also of course the question of changing dosages over time when they 
did no longer exist as current medications, so I am not sure whether the 
selection would have to combine data from the current medication table and the 
audit table of no-longer-current medications?

-- Jim