Hi Jason, Thank your advice.
Regards, Tantely. On Mon, Sep 12, 2016 at 9:31 AM, Jason Pickering < [email protected]> wrote: > Hi Tantely, > > 1- the table where are stored all organization units groups with the list > of their members. > > \d orgunitgroupmembers > > 2- the table where are stored the datasets assigned to the organization > units > > \d datasetsource > > 3- the table where are stored the organization units assigned to all users > > \d usermembership > > You should not really try and update these tables manually. Its much > better to use the API. > > > Regards, > Jason > > > > On Mon, Sep 12, 2016 at 7:52 AM, Raminosoa Rabemanantsoa, Tantely < > [email protected]> wrote: > >> Dear Members, >> >> I am looking for 3 database tables: >> >> 1- the table where are stored all organization units groups with the list >> of their members. >> 2- the table where are stored the datasets assigned to the organization >> units >> 3- the table where are stored the organization units assigned to all >> users >> >> Does anyone know in which tables should I query to select and update >> their records? I am using DHIS2 2.19 and I connect to the DHIS2 database >> directly with psql. >> >> Thank you for your advice. >> >> Regards, >> >> Tantely. >> >> *This message and its attachments are confidential and solely for the >> intended recipients. If received in error, please delete them and notify >> the sender via reply e-mail immediately.* >> _______________________________________________ >> Mailing list: https://launchpad.net/~dhis2-devs >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-devs >> More help : https://help.launchpad.net/ListHelp >> > -- > Jason P. Pickering > email: [email protected] > tel:+46764147049 > -- *This message and its attachments are confidential and solely for the intended recipients. If received in error, please delete them and notify the sender via reply e-mail immediately.*
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
