dhis2-users team mailing list archive

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

Hi Greg, Tim,

Thank you for sharing the alternative way using API. Is it possible to go
backward using the API, if I would like to go beyound getting the list of
assigned dataSets and this time assign a set of dataSets to a group of OU?
That will also be helpful!

Kind Regards,

Tantely

On Tue, Feb 21, 2017 at 10:54 PM, Greg Wilson <gwilson@xxxxxxxxxxxxxx>
wrote:

> And to tag onto Tim's message, if you know the particular OU of interest,
> you can all datasets associated with it via:
>   https://play.dhis2.org/demo/api/dataSet?filter=organisationUnits.id:eq:
> THEOUUIDGOESHERE
>
> Greg
>
>
> On Tue, Feb 21, 2017 at 1:41 PM, Timothy Harding <tharding@xxxxxxxxxxxxxx>
> wrote:
>
>> An alternative way to do this is to use an API call to the
>> /organisationUnits/ and have it also return the names of the dataSets
>> assigned:
>>
>> https://play.dhis2.org/dev/api/organisationUnits/?fields=nam
>> e,id,dataSets[name,id]&paging=false
>>
>> Replace the "https://play.dhis2.org/dev"; with your DHIS 2 instance
>>
>> [image: Inline image 1]
>>
>> Also note that paging=false will return all the org units, depending on
>> how many you have, this can take a while to return to your browser.
>>
>>
>>
>>
>>
>>
>> *Timothy Harding*
>> Sr. Systems Analyst, BAO Systems
>> +1 202-536-1541 | tharding@xxxxxxxxxxxxxx | http://www.baosystems.com | Skype:
>> hardingt@xxxxxxxxx | 2900 K Street, Suite 406, Washington D.C. 20007
>>
>> On Tue, Feb 21, 2017 at 1:31 PM, Jim Grace <jim@xxxxxxxxx> wrote:
>>
>>> If you want to show each pair of assigned orgUnit and dataSet, try
>>> something like:
>>>
>>> SELECT ou.name AS orgunit, ds.name AS dataset
>>> FROM dataset ds
>>> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
>>> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
>>> ORDER BY ou.name, ds.name;
>>>
>>> If you want only one row per orgUnit and a column that concatenates all
>>> assigned dataset names, try (in Postgresql):
>>>
>>> SELECT ou.name AS orgunit, string_agg(ds.name, ' | ' ORDER BY ds.name)
>>> AS datasets
>>> FROM dataset ds
>>> JOIN datasetsource dss ON dss.datasetid = ds.datasetid
>>> JOIN organisationunit ou ON ou.organisationunitid = dss.sourceid
>>> GROUP BY ou.name
>>> ORDER BY ou.name;
>>>
>>> Cheers,
>>> Jim
>>>
>>>
>>> On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely <
>>> traminosoa@xxxxxxxxxx> wrote:
>>>
>>>> Dear Community,
>>>>
>>>> I am trying to pull out the list of all orgUnits and the name of the
>>>> questionnaire assigned to each of them via SQL View. In which table should
>>>> I base the SQL query in order to have the list of dataSet assigned to an
>>>> orgUnit?
>>>>
>>>> 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-devs
>>>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-devs
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>>
>>> --
>>> Jim Grace
>>> Core developer, DHIS 2
>>> HISP US Inc.
>>> http://www.dhis2.org <https://www.dhis2.org/>
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Greg Wilson
> BAO Systems
>

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