dhis2-devs team mailing list archive

[riddy ndoma <riddyndoma@xxxxxxxxx>]

Thank you to the team for your support,

Hi @Ola, then how to ensure that the resources automatically generate
tables? as you have said that there is possibility of activated!


2013/11/14 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
>>
>>


-- 
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)