Thank you John for the information. Kind Regards,
Tantely. On Sun, Feb 5, 2017 at 6:47 PM, John Mukulu <john.f.muk...@gmail.com> wrote: > 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 >> > -- *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-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
