On 11 May 2011 11:19, Friedman, Roger (CDC/CGH/DGHA) (CTR) <r...@cdc.gov>wrote:
> What I hear you saying is that we can get this in a report table but not in > an indicator calculation or validation expression. > > I think it will be a lot easier for you to use the normal approach of defining indicators and report tables and not use any custom SQL directly. Ola ------ > 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.picker...@gmail.com] > Sent: Wednesday, May 11, 2011 5:01 AM > To: Friedman, Roger (CDC/CGH/DGHA) (CTR) > Cc: dhis2-users@lists.launchpad.net > 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) > <r...@cdc.gov> 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@lists.launchpad.net > > Unsubscribe : https://launchpad.net/~dhis2-users > > More help : https://help.launchpad.net/ListHelp > > > > > > -- > Jason P. Pickering > email: jason.p.picker...@gmail.com > tel:+260974901293 > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : dhis2-users@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
