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

[Karsten Hilbert]

On Thu, Sep 08, 2011 at 09:24:55AM -0700, Jim Busser wrote:

> 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>$
>          )
>       ;
> 
> ??

Indeed.

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