Re: [Gnumed-devel] import patient data - basic procedure

[Karsten Hilbert]

On Mon, Apr 29, 2013 at 12:27:16PM +0200, Karsten Hilbert wrote:

> > # to query all substances taken by all patients (non-distinct)
> > select *
> > from
> >     clin.substance_intake
> > --> generates 19 results
> > 
> > 
> > # to query all directly-referenced substances taken by all patients
> > select *
> > from
> >     clin.substance_intake
> >             inner join
> >     ref.consumable_substance
> >             on 
> > (clin.substance_intake.fk_substance=ref.consumable_substance.pk)
> > ORDER BY clin_when
> > 
> > # to query all indirectly-referenced (via brand) substances taken by all 
> > patients
> > select age(date_trunc('day',now()),date_trunc('day', intake.clin_when)), 
> > atc_code, brand.description AS brand, brand.preparation AS form, schedule, 
> > aim, duration, intake_is_approved_of, discontinued, narrative
> > from
> >     clin.substance_intake AS intake
> >             inner join
> >             ref.lnk_substance2brand
> >                     on (intake.fk_drug_component=ref.lnk_substance2brand.pk)
> >             inner join
> >             ref.branded_drug AS brand
> >                     on (brand.pk=ref.lnk_substance2brand.fk_brand)
> > ORDER BY clin_when

The above inspired me to add the attached reports vor 1.3.4/18.4.

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

v18-cfg-report_query-fixup.sql
Description: application/sql