Thank you for those information, they are helpful! I will be back in case I have further questions.
Tantely.
···
On Wed, Feb 22, 2017 at 4:23 PM, Timothy Harding tharding@baosystems.com wrote:
No problem Tantely,
You can assign datasets to an OU group here:
https://play.dhis2.org/demo/dhis-web-maintenance/#/edit/dataSetSection/dataSet/lyLU2wR22tC
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:
Timothy Harding
Sr. Systems Analyst, BAO Systems
+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007
On Wed, Feb 22, 2017 at 12:49 AM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org 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
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.
On Tue, Feb 21, 2017 at 10:54 PM, Greg Wilson gwilson@baosystems.com 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@baosystems.com 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=name,id,dataSets[name,id]&paging=false
Replace the “https://play.dhis2.org/dev” with your DHIS 2 instance
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.
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
–
Greg Wilson
BAO Systems
Timothy Harding
Sr. Systems Analyst, BAO Systems
+1 202-536-1541 | tharding@baosystems.com | http://www.baosystems.com | Skype: hardingt@gmail.com | 2900 K Street, Suite 406, Washington D.C. 20007
On Tue, Feb 21, 2017 at 1:31 PM, Jim Grace jim@dhis2.org 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
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp
On Tue, Feb 21, 2017 at 12:53 PM, Raminosoa Rabemanantsoa, Tantely traminosoa@mikolo.org 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@lists.launchpad.net
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
–