Hi Ed, This should get you started:
SELECT dv.dataelementid, dv.value, ou.name FROM datavalue dv JOIN organisationunit ou ON ou.organisationunitid = dv.sourceid; Best, David On Tue, Jun 19, 2018 at 2:21 PM Edward Robinson < erobin...@projectbalance.com> wrote: > How can the OU be determined for the data in the datavalues table? > > The fields are dataelementid, periodid, sourceid, categoryoptioncomboid, > attributeoptioncomboid, value, storedby, created, lastupdated, comment, > followup, deleted > > I’m guessing it involves the sourceid field (and possibly others) but I’m > having a hard time figuring it out at the moment. > > > > Thanks in advance! > > Ed > _______________________________________________ > 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 > -- *David Huser* DHIS2 Support Specialist dhu...@baosystems.com | https://baosystems.com | 2900 K Street, Suite 507, Washington D.C. 20007
_______________________________________________ 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
