dhis2-users team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

On 11 May 2011 11:19, Friedman, Roger (CDC/CGH/DGHA) (CTR) <rdf4@xxxxxxx>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.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
>
>
> _______________________________________________
> 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
>