[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Report generator query for current patient medication
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Report generator query for current patient medication and lab results |
Date: |
Thu, 8 Sep 2011 12:24:10 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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
- Re: [Gnumed-devel] Report generator query for current patient medication and lab results,
Karsten Hilbert <=