dhis2-users team mailing list archive

["Friedman, Roger (CDC/CGH/DGHA) (CTR)" <rdf4@xxxxxxx>]

What I hear you saying is that we can get this in a report table but not in an indicator calculation or validation expression.

Also, my recollection is that custom SQL view only allows select statements, so we can't use it to update a hidden data element, right?  And we could muck with the Hibernate definition to get a virtual column in the period table but we'd have no way to use it.

-----Original Message-----
From: Jason Pickering [mailto:jason.p.pickering@xxxxxxxxx] 
Sent: Wednesday, May 11, 2011 5:01 AM
To: Friedman, Roger (CDC/CGH/DGHA) (CTR)
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
Subject: Re: [Dhis2-users] Days per period

It would be available through a pretty trivial SQL statement if you
are calculating this on an external report.

SELECT periodid, enddate-startdate as nbr_days FROM period in
Postgresql will give you the number of days in a given period along
with the periodid. you could then join this to the aggregated data
elements you mention with periodid and the aggregateddatavalue table.

 I think the easiest way would be through a custom SQL view (which is
now supported) or through a report rather than direct calculation
through the system.

Regards,
Jason



On Wed, May 11, 2011 at 10:56 AM, Friedman, Roger (CDC/CGH/DGHA) (CTR)
<rdf4@xxxxxxx> wrote:
> Listers --
>    We need to calculate bed occupancy rates.  We have the number of
> beds per ward and the number of person-days of bed use per month, but we
> need the number of days per month.  Is that available in some way from
> the system or are we going to have to key it?
> Thanks, Roger
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>



-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+260974901293