[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] import patient data - basic procedure
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] import patient data - basic procedure |
Date: |
Sun, 5 May 2013 22:46:58 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- Re: [Gnumed-devel] import patient data - basic procedure,
Karsten Hilbert <=