[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Gnumed-devel] user contributed report

From: Karsten Hilbert
Subject: Re: [Gnumed-devel] user contributed report
Date: Mon, 9 Apr 2007 18:50:14 +0200
User-agent: Mutt/1.5.13 (2006-08-11)

For those wondering whether the below is spam ...

It is not. It is a feature of the next release :-)

Version 0.2.6 has a data mining plugin aka report generator.
That tool allows me to run arbitrary (read only) queries
against the database. If you give a name to the query and
save it it can be re-used later (Syan, there's your worklist
for after-management). The tool also features a button
[contribute] - which, if pressed, sends the report name and
query to our community mailing list for all to enjoy...

The report generator widget has a phrasewheel to pull up
report definitions. You can type in (part of) a report name.
Or you could type in a table name which brings up all
reports somehow touching that table in the SQL they run :-)

Phrasewheels are nice :-)


On Mon, Apr 09, 2007 at 12:28:35PM -0400, GNUmed Report Generator wrote:
> Subject: [Gnumed-devel] user contributed report
> This is a report contributed by a user:
> #-------------------------------------
> Tagesliste
> select
>       date_trunc('minute', clin_when),
>       narrative
> from
>       clin.v_emr_journal
> where
>       pk_encounter in (
>               -- ecnounters in range:
>               select pk_encounter from
>                       clin.v_pat_encounters
>               where
>                       started between dem.date_trunc_utc('day', now()) and 
> now()
>       )
>       and modified_by like '%' || current_user || '%'
> order by clin_when
> #-------------------------------------
> The GNUmed client.

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

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