← Back to team overview

dhis2-devs team mailing list archive

Re: Getting the OU for items recorded in datavalues table

 

Ah, got it, makes sense,
Thanks
Ed

From: Knut Staring <knutst@xxxxxxxxx>
Sent: Sunday, 24 June 2018 8:36 PM
To: Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx>
Cc: David Huser <dhuser@xxxxxxxxxxxxxx>; DHIS 2 developers <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-devs] Getting the OU for items recorded in datavalues table

This is an unfortunate relic in a few key tables. Dates back to 2005...

On Tue, Jun 19, 2018, 2:35 PM Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx<mailto:erobinson@xxxxxxxxxxxxxxxxxx>> wrote:
Oh wow, that simple?  Sourceid = organisationunitid?
Thanks for the quick response David.  For some reason I was expecting organisationunitid to be present in the datavalue table.  Do you know the reason it’s called sourceid?
Ed

From: David Huser <dhuser@xxxxxxxxxxxxxx<mailto:dhuser@xxxxxxxxxxxxxx>>
Sent: Tuesday, 19 June 2018 2:33 PM
To: Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx<mailto:erobinson@xxxxxxxxxxxxxxxxxx>>
Cc: DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>>
Subject: Re: [Dhis2-devs] Getting the OU for items recorded in datavalues table

Hi Ed,

This should get you started:

SELECT dv.dataelementid, dv.value, ou.name<http://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<mailto: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<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp


--
[https://docs.google.com/uc?export=download&id=0B3FU6Lx45t71cUgwM0swdzZOcUk&revid=0B3FU6Lx45t71VGRUVElxbzIxM2VsOXVqN0hZUFRtMk1ZaXcwPQ]


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


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Follow ups

References