dhis2-devs team mailing list archive

[David Huser <dhuser@xxxxxxxxxxxxxx>]

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 <
erobinson@xxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>


-- 


*David Huser*
DHIS2 Support Specialist
dhuser@xxxxxxxxxxxxxx | https://baosystems.com |  2900 K Street, Suite 507,
Washington D.C. 20007