dhis2-devs team mailing list archive

[Brajesh Murari <brajesh.murari@xxxxxxxxx>]

Welcome Robin

On Wed 20 Jun, 2018, 1:08 PM Edward Robinson, <erobinson@xxxxxxxxxxxxxxxxxx>
wrote:

> Thank you Brajesh,
>
> Ed
>
>
>
> *From:* Brajesh Murari <brajesh.murari@xxxxxxxxx>
> *Sent:* Tuesday, 19 June 2018 4:47 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
>
>
>
> sourceid is available for distinguishing different types of
> organizationunit. It is one of id available since DHIS 1. In some of the
> DHIS2 releases, it was removed and later on it was found very useful, so it
> was included. It's like parent to organisationunit.
>
>
>
> BM
>
> On Tue 19 Jun, 2018, 6:06 PM Edward Robinson, <
> 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>
> *Sent:* Tuesday, 19 June 2018 2:33 PM
> *To:* Edward Robinson <erobinson@xxxxxxxxxxxxxxxxxx>
> *Cc:* DHIS 2 Developers list <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
> 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
>
>
>
> _______________________________________________
> 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
>
>