Re: [Dhis2-users] Organization Units UIDs

Hi Gerald This should work: SELECT uid, name FROM organisationunit Best regards David On 10.02.2016 17:47, gerald thomas wrote: Dear All, Please can someone help with the query on PostgreSQL that will return all the facilities and their UIDs?? Thanks for your usual cooperation.

Re: [Dhis2-users] Organization Units UIDs

Dear David, It didn't work. On 2/11/16, David Huser wrote: > Hi Gerald > > This should work: > > SELECT uid, name FROM organisationunit > > Best regards > David > > > On 10.02.2016 17:47, gerald thomas wrote: >> Dear All, >> Please can someone help with the query on

Re: [Dhis2-users] Organization Units UIDs

Hi Gerald I forgot to add that you can filter on the orgunit level also: SELECT name, uid FROM organisationunit WHERE hierarchylevel = 4 where 4 is your lowest level / the level where you have your facilities On 11.02.2016 10:57, David Huser wrote: Hi Gerald This should work: SELECT uid,

Re: [Dhis2-users] Organization Units UIDs

Hi Gerald, Please give more details. Knut Dear David, It didn't work. On 2/11/16, David Huser wrote: > Hi Gerald > > This should work: > > SELECT uid, name FROM organisationunit > > Best regards > David > > > On 10.02.2016 17:47, gerald thomas wrote: >> Dear All, >>

[Dhis2-users] Organization Units UIDs

Dear All, Please can someone help with the query on PostgreSQL that will return all the facilities and their UIDs?? Thanks for your usual cooperation. -- Regards, Gerald ___ Mailing list: https://launchpad.net/~dhis2-users Post to :

Re: [Dhis2-users] Organization Units UIDs

Hi Gerald, We have an automated way to help extract this data into the InterLinked Registry. You can see an example of a DHIS2 Web App for this here: https://www.youtube.com/watch?v=J7Lefmcl6X0 It can also be automated using this script here: