gnumed-devel
[Top][All Lists]
Advanced

[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


reply via email to

[Prev in Thread] Current Thread [Next in Thread]