Re: [Gnumed-devel] Statistics

[Busser, Jim]

> select count(1)
> from dem.identity d_i
> where
>       d_i.pk in (
>               select distinct fk_patient from clin.encounter
>               where
>                       fk_type in (select pk from clin.encounter_type where 
> description in ('list', 'of', 'interesting', 'types'))
>                               and
>                       started between 'year-01-01' and 'year-12-31'
>       )
> ;
> 
> Untested.

Tested using 'seen in clinic' in place of

        'list', 'of', 'interesting', 'types'

and by inputting date range '2012-01-01' and '2012-12-31'

… works

-- Jim