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 <[email protected]> > 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" <[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 >> >> -- 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
