dhis2-users team mailing list archive

[David Huser <david.huser@xxxxxxxxxxxx>]

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: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp

--
*David Huser*
Informatics Specialist
Swiss Centre for International Health
Tel: +41 79 740 63 41
Skype: dafhus
david.huser@xxxxxxxxxxxx

*Swiss Tropical and Public Health Institute*
Socinstrasse 57, P.O. Box
4002 Basel, Switzerland
www.swisstph.ch