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 <[email protected]> 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 <[email protected]> > >> One place to start is the *generated* table (resource table) called >> _orgunitstructure >> >> Knut >> >> >> On Thu, Nov 14, 2013 at 2:43 PM, riddy ndoma <[email protected]>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 : [email protected] >>> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
