Organization Units UIDs

Support - Assistance technique
1

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

2

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:

https://github.com/openhie/openinfoman-dhis/blob/master/resources/scripts/publish_to_ilr.sh

I am happy to talk to you this more

Cheers,

-carl

···

On Feb 10, 2016, at 11:47 AM, gerald thomas gerald17006@gmail.com 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.

–
Regards,

Gerald

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

3

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.

4

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

  _______________________________________________

  Mailing list: Post to���� : Unsubscribe : More help�� :

–

  <small>
    **David Huser**

    Informatics Specialist

    Swiss Centre for International Health

    Tel: +41 79 740 63 41

    Skype: dafhus

    david.huser@swisstph.org

    **Swiss Tropical and Public Health Institute**

    Socinstrasse 57, P.O. Box

    4002 Basel, Switzerland

    [www.swisstph.ch](www.swisstph.ch)

  </small>

https://launchpad.net/~dhis2-users
dhis2-users@lists.launchpad.net
https://launchpad.net/~dhis2-users
https://help.launchpad.net/ListHelp

5

Dear David,

It didn't work.

···

On 2/11/16, David Huser <david.huser@swisstph.org> 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 PostgreSQL that will return
all the facilities and their UIDs??

Thanks for your usual cooperation.

_______________________________________________
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

--
Regards,

Gerald

6

Hi Gerald,

Please give more details.

Knut

Dear David,

It didn’t work.

···

On 2/11/16, David Huser david.huser@swisstph.org 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 PostgreSQL that will return

all the facilities and their UIDs??

Thanks for your usual cooperation.

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

–

Regards,

Gerald

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