Executing a report which does not depend on aggregate data?

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@gmail.com
tel:+260974901293

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@gmail.com 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@gmail.com
tel:+260974901293


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp