Understood, thanks everyone, Regards Ed From: Calle Hedberg <[email protected]> Sent: Monday, 25 June 2018 1:44 AM To: Brajesh Murari <[email protected]> Cc: Edward Robinson <[email protected]>; DHIS 2 developers <[email protected]> Subject: Re: [Dhis2-devs] Getting the OU for items recorded in datavalues table
Hi, Incorrect - the term "sourceid" has never been used in DHIS v1. DHIS1 introduced and maintained the principle that the id reference field for any table would be called <tablename>id. I'm not sure WHY it was decided at the time to change this principle for some of the organisationunitid foreign key fields, but the idea was dropped quickly. Ola or Lars might recall... regards calle On 19 June 2018 at 16:46, Brajesh Murari <[email protected]<mailto:[email protected]>> wrote: 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, <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> Sent: Tuesday, 19 June 2018 2:33 PM To: Edward Robinson <[email protected]<mailto:[email protected]>> Cc: DHIS 2 Developers list <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> 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 : [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> | https://baosystems.com | 2900 K Street, Suite 507, Washington D.C. 20007 _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected]<mailto:[email protected]> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected]<mailto:[email protected]> Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp -- ******************************************* Calle Hedberg 46D Alma Road, 7700 Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472 Cell: +27-82-853-5352 Iridium SatPhone: +8816-315-19119 Email: [email protected]<mailto:[email protected]> Skype: calle_hedberg *******************************************
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
