[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 :-)
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
- [Gnumed-devel] user contributed report, GNUmed Report Generator, 2007/04/09
- Re: [Gnumed-devel] user contributed report,
Karsten Hilbert <=
- Re: [Gnumed-devel] user contributed report, J Busser, 2007/04/09
- Re: [Gnumed-devel] user contributed report, Karsten Hilbert, 2007/04/09
- Message not available
- Re: [Gnumed-devel] user contributed report, Karsten Hilbert, 2007/04/09
- Re: [Gnumed-devel] user contributed report, Sebastian Hilbert, 2007/04/09
- Re: [Gnumed-devel] user contributed report, Karsten Hilbert, 2007/04/10
- Re: [Gnumed-devel] user contributed report, Tim Churches, 2007/04/10
- Re: [Gnumed-devel] user contributed report, Karsten Hilbert, 2007/04/10
- Re: [Gnumed-devel] user contributed report, Tim Churches, 2007/04/10
- Re: [Gnumed-devel] user contributed report, Karsten Hilbert, 2007/04/10