Re: [Gnumed-devel] Re: Kirk's EMR tree episode "postop infected laceration..."

[Karsten Hilbert]

On Sun, Jun 21, 2009 at 01:02:48PM -0700, Jim Busser wrote:

> Meant to specify that the count of problems would, under a revised  
> approach (if accepted), be:
>
> - one per active episode under Unattributed (not counting  
> "Unattributed") plus
> - one per active Health Issue (regardless if it has an active episode  
> inside it

In database terms:

        select ((
                -- active episodes w/o health issue
                select count(1) from clin.v_problem_list where pk_health_issue 
is null
        ) + (
                -- relevant health issues w/o an active episode
                select count(1) from clin.v_problem_list where pk_episode is 
null
        ))

to whom it may concern.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346