Re: [Gnumed-devel] user contributed report

[Karsten Hilbert]

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 :-)

Karsten

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 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346