[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: |
Jim Busser |
Subject: |
Re: [Gnumed-devel] Report generator query for current patient medication and lab results |
Date: |
Thu, 08 Sep 2011 09:24:55 -0700 |
On 2011-09-08, at 3:24 AM, Karsten Hilbert wrote:
> The report generator now knows the
>
> $<ID_active_patient>$
>
> placeholder (which can NOT be used in form templates as is).
So… one can limit their query to the currently-active patient by including, in
the WHERE clause, the placeholder $<ID_active_patient>$ with something like:
<table_or_view_relatable_to.pk_identity> = $<ID_active_patient>$
or something like
EXISTS (
SELECT 1
FROM
table_or_view_containing_else_relatable_to_pk_patient
WHERE
column_containing_pk = $<ID_active_patient>$
)
;
??
-- Jim