← Back to team overview

dhis2-users team mailing list archive

Re: [Dhis2-devs] Groups - Tables

 

Hi there,
.
I am trying to connect to those resources using the web API and it seems
that the requested resources are not available. Could you please mention
the way to connect to them by using DHIS2 2.19?

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