[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] experiments with gnumed - multiusers vnc, importing a
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] experiments with gnumed - multiusers vnc, importing an au emr |
Date: |
Sun, 23 Apr 2006 18:50:20 +0200 |
User-agent: |
Mutt/1.5.11+cvs20060403 |
On Sun, Apr 23, 2006 at 04:34:27PM +0200, Karsten Hilbert wrote:
> > The downside is that the big records get lost in the names; maybe there
> > should
> > be a custom function that calculates the size of the emr record, and can be
> > accessed by identity id,
> You mean like this ?
>
> select count(*) from clin.encounter where fk_patient = X;
> select count(*) from clin.episode where fk_patient = X;
> select count(*) from clin.v_pat_items where fk_patient = X;
> select count(*) from blobs.doc_med where fk_patient = X;
>
> Not bad an idea but the count()s will eat quite some time.
> It should be accessible on-demand, though.
This is now supported: main menu "EMR" -> Show Summary
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346