dhis2-devs team mailing list archive

[Juma Lungo <jlungo@xxxxxxxxx>]

Hi,

I would like to create a report to list orgunit code, name, ... and 'ownership'. Which table stores the ownership standard list?

Here is the SQL:

SELECT organisationunit.code, organisationunit.name, organisationunit.coordinates, orgunitgroup.name as Type, organisationunit.contactperson, organisationunit.phonenumber FROM organisationunit INNER JOIN orgunitgroupmembers ON organisationunit.organisationunitid = orgunitgroupmembers.organisationunitid INNER JOIN orgunitgroup ON (orgunitgroup.orgunitgroupid = orgunitgroupmembers.orgunitgroupid) AND organisationunit.parentid = 101