Welcome Robin On Wed 20 Jun, 2018, 1:08 PM Edward Robinson, <erobin...@projectbalance.com> wrote:
> Thank you Brajesh, > > Ed > > > > *From:* Brajesh Murari <brajesh.mur...@gmail.com> > *Sent:* Tuesday, 19 June 2018 4:47 PM > *To:* Edward Robinson <erobin...@projectbalance.com> > *Cc:* David Huser <dhu...@baosystems.com>; DHIS 2 developers < > dhis2-devs@lists.launchpad.net> > *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, < > erobin...@projectbalance.com> 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 <dhu...@baosystems.com> > *Sent:* Tuesday, 19 June 2018 2:33 PM > *To:* Edward Robinson <erobin...@projectbalance.com> > *Cc:* DHIS 2 Developers list <dhis2-devs@lists.launchpad.net> > *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 < > 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 > >
_______________________________________________ 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
