dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #48539
Re: [Dhis2-users] Table for SQL query for Indicators
Hello Raminosoa,
Analytics supports generation of query based on data, period and orgunit
selection. You can use pivot table, select your periods, orgunits and
indicators and use download option under advanced menu to download the
query.
I can't recall, but I think support for generation sql query even for
indicators was added either in 2.23, 2.24 or 2.25 so you could also try to
explore this option.
On 3 Feb 2017 11:05, "Raminosoa Rabemanantsoa, Tantely" <
traminosoa@xxxxxxxxxx> wrote:
> Dear friends,
>
> I am trying to output data of a questionnaire (called DataSetName here)
> from SQL View for the period of September 2016 from data values using the
> following code:
>
> select dv.sourceid as organisationunitid, ou.name, ou.shortname, ou.code
> as CodeAC, de.name as intitule, pe.startdate, pe.enddate,
> coc.categoryoptioncomboname, dv.value from datavalue dv inner join
> organisationunit ou on (dv.sourceid=ou.organisationunitid) inner join
> dataelement de on (dv.dataelementid=de.dataelementid) inner join period
> pe on (pe.startdate='2016-09-01') inner join _categoryoptioncomboname coc
> on (dv.categoryoptioncomboid=coc.categoryoptioncomboid) where
> (dv.dataelementid in (select dataelementid from datasetmembers where
> datasetid in (select datasetid from dataset where name='DataSetName')));
>
> If I would like to output data from indicator tables, on which table in
> DHIS2 should I base the select query?
>
> Thank you for your support!
>
> Kind Regards,
>
> Tantely.
>
> *This message and its attachments are confidential and solely for the
> intended recipients. If received in error, please delete them and notify
> the sender via reply e-mail immediately.*
> _______________________________________________
> 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
>
>
Follow ups
References