dhis2-devs team mailing list archive

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

Hi Tim,

Thank you for those information, they are helpful! I will be back in case I
have further questions.

Regards,

Tantely.

On Wed, Feb 22, 2017 at 4:23 PM, Timothy Harding <tharding@xxxxxxxxxxxxxx>
wrote:

> No problem Tantely,
>
> You can assign datasets to an OU group here:
>
> https://play.dhis2.org/demo/dhis-web-maintenance/#/edit/data
> SetSection/dataSet/lyLU2wR22tC
> [image: Inline image 2]
>
>
> Or if you wanted to see what datasets are currently assigned to Org Units
> of a specific group, I'll build the api query below like I when working in
> the browser:
>
>    - https://play.dhis2.org/demo/api/organisationUnitGroups/
>    - https://play.dhis2.org/demo/api/organisationUnitGroups/CXw2yu5fodb
>    - https://play.dhis2.org/demo/api/organisationUnitGroups/
>    CXw2yu5fodb?fields=name,id,organisationUnits[name,id]
>    <https://play.dhis2.org/demo/api/organisationUnitGroups/CXw2yu5fodb?fields=name,id,organisationUnits[name,id]>
>    - https://play.dhis2.org/demo/api/organisationUnitGroups/
>    CXw2yu5fodb?fields=name,id,organisationUnits[name,id,dataSets[name,id]]
>    <https://play.dhis2.org/demo/api/organisationUnitGroups/CXw2yu5fodb?fields=name,id,organisationUnits[name,id,dataSets[name,id]]>
>
> You can find help for how to write these api queries yourself here:
> https://docs.dhis2.org/master/en/developer/html/
> dhis2_developer_manual_full.html
>
>
>
>
> *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 Wed, Feb 22, 2017 at 12:49 AM, Raminosoa Rabemanantsoa, Tantely <
> traminosoa@xxxxxxxxxx> wrote:
>
>> 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=organisationU
>>> nits.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.*
>>
>

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