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
_______________________________________________
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
