dhis2-devs team mailing list archive

[Murod Latifov <mlatifov@xxxxxxxxx>]

Hi Riddy,

Actually there is no link between org unit level and orgunit tables.
Moreover level of org unit is not persisted, that means each time the level
of orgunit is computed when needed. I think this is unnecessary computation
while level org units is stable for the long time or all over. Now I
see _orgunitstructure
provides some sort of persistence to level orgunit structure.

regards,
murod



On Thu, Nov 14, 2013 at 6:53 PM, riddy ndoma <riddyndoma@xxxxxxxxx> wrote:

> It is managed from the resource table _orgunitstructure. Since according
> to the diagram you gave me the orgunitlevel table is connected only with
> the Map table
>
>
> 2013/11/14 Knut Staring <knutst@xxxxxxxxx>
>
>> One place to start is the *generated* table (resource table) called
>> _orgunitstructure
>>
>> Knut
>>
>>
>> On Thu, Nov 14, 2013 at 2:43 PM, riddy ndoma <riddyndoma@xxxxxxxxx>wrote:
>>
>>> Hello,
>>> I am trying to explore the structure of the database administrator
>>> entant that perfect mastery of queries that the GUI does not allow dhis2, I
>>> wanted to know the table that connects organisationunit table and
>>> organitlevel table?
>>>
>>> --
>>> Riddy NDOMA
>>> Software Developer
>>> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
>>> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
>>> *Blog:* http://riddyndoma.blogspot.com/
>>>
>>> Vous servir est mon désire (Serving you is my desire)
>>>
>>> _______________________________________________
>>> 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
>>>
>>>
>>
>>
>> --
>> Knut Staring
>> Dept. of Informatics, University of Oslo
>> +4791880522
>> http://dhis2.org
>>
>
>
>
> --
> Riddy NDOMA
> Software Developer
> *Skype:* riddyndoma, *G+:* riddyndoma, *FB:* riddy ndoma
> *Twitter:* riddyndoma, *LinkedIn:* riddy ndoma
> *Blog:* http://riddyndoma.blogspot.com/
>
> Vous servir est mon désire (Serving you is my desire)
>
> _______________________________________________
> 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
>
>