dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

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 <
traminosoa@xxxxxxxxxx> 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-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049