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

[Karsten Hilbert]

On Sun, Aug 28, 2011 at 01:14:23PM -0700, Jim Busser wrote:

> >> 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

...

> More basically, if the current patient happened to have pk = 12 it is 
> possible to have a query in which one can specify
> 
>       where pk_patient = 12
> 
> however even when this query is saved (e.g. with report name
> 
>       XXXXX for current patient
> 
> one cannot use it for any other patient until one would
> manually insert the pk for whomever would be this patient.
> So I am wondering whether GNUmed has a placeholder or syntax
> which could be saved in a query which would limit the
> matches to the rows which pertain to the current patient?

The report generator now knows the

        $<ID_active_patient>$

placeholder (which can NOT be used in form templates as is).

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346