dhis2-devs team mailing list archive

[Ola Hodne Titlestad <olati@xxxxxxxxxx>]

Hi Riddy,

The resource tables are not part of the schema or data model as such, but
generated by the system (from data administration) to make it easier for db
people to make select queries for reports etc. One example is the
hierarchical listing of orgunits in the _orgunitstructure table. This table
is updated by the nightly scheduling job, if that is enabled, or manually
from Data Administration. So that table might be out of sync with the
orgunit table, if you do not make sure it is re-generated.

The levels/hierarchy of orgunits are managed through the parent reference
in the organisationunit table.

The orgunitlevel table is just to store labels for each level, e.g. used in
the level selector in GIS.

Ola
------
On 14 Nov 2013 14:54, "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
>
>