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" < tramino...@mikolo.org> 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-us...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ 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
