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 to activate it!


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



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