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