Hi Riddy, Have a look in Data Administration->Scheduling. There is an option for Resource Tables there. The scheduled tasks take place at midnight every day. You can read more about Scheduling in the manual.
Ola ----- ---------------------------------- Ola Hodne Titlestad (Mr) HISP Department of Informatics University of Oslo Mobile: +47 48069736 Home address: Eftasåsen 68, 0687 Oslo, Norway. Googlemaps link<https://maps.google.com/maps?q=Eftas%C3%A5sen+68,+0687+Oslo,+Norge&hl=en&ie=UTF8&sll=59.893855,10.785116&sspn=0.222842,0.585709&oq=eftas%C3%A5sen+68,+0687+Oslo,+&t=h&hnear=Eftas%C3%A5sen+68,+%C3%98stensj%C3%B8,+0687+Oslo,+Norway&z=16> On 14 November 2013 15:28, riddy ndoma <[email protected]> wrote: > 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
