← Back to team overview

dhis2-devs team mailing list archive

Re: Groups - Tables

 

Hi Jason,

Thank your advice.

Regards,

Tantely.

On Mon, Sep 12, 2016 at 9:31 AM, Jason Pickering <
jason.p.pickering@xxxxxxxxx> 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 <
> 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
>

-- 
*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.*

References