← Back to team overview

dhis2-devs team mailing list archive

Re: Executing a report which does not depend on aggregate data?

 

Hi Jason,

what DHIS function are you using for this query? When are you prompted for
aggregated data?

Lars


On Tue, Feb 22, 2011 at 11:18 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> wrote:

>
> I have a report which basically is just a listing of data sets and sources.
>
> The data source looks like this..
>
> SELECT ou.name as orgunit, ds.name as datasetname FROM datasetsource dsm
> INNER JOIN organisationunit ou on ou.organisationunitid = dsm.sourceid
> INNER JOIN dataset ds on dsm.datasetid = ds.datasetid
> ORDER BY ds.name, ou.name
>
> So, just give me a list of all datasets and orgunits which belong to
> them...
>
> Not that it is a big deal really, but it is a bit confusing when DHIS2
> prompts me for "Get aggregated data". Seems unnecessary and a bit confusing
> really. Bug? Blueprint? Ignore?
>
> Regards,
> Jason
>
> --
> Jason P. Pickering
> email: jason.p.pickering@xxxxxxxxx
> tel:+260974901293
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>

References