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