[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 21:33:39 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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