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 < tramino...@mikolo.org> 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 : dhis2-d...@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: jason.p.picker...@gmail.com tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
