dhis2-users team mailing list archive

["Raminosoa Rabemanantsoa, Tantely" <traminosoa@xxxxxxxxxx>]

Thank you John for the information.

Kind Regards,

Tantely.

On Sun, Feb 5, 2017 at 6:47 PM, John Mukulu <john.f.mukulu@xxxxxxxxx> 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" <
> 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
>>
>

-- 
*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.*