dhis2-devs team mailing list archive

[Calle Hedberg <calle.hedberg@xxxxxxxxx>]

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 <brajesh.murari@xxxxxxxxx> 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, <
> 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
>>
>
> _______________________________________________
> 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
>
>


-- 

*******************************************

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: calle.hedberg@xxxxxxxxx

Skype: calle_hedberg

*******************************************