did you try using a PUT through the Web API, or trough SQL directly in the
database?
Which database table contains these definitions? SQL will be a faster
option.
···
regards,
Lars
On Wed, Jan 25, 2017 at 10:33 AM, Morina Matasi <morena.motsieng@gmail.com > > wrote:
Is it possible to modify a report table through the Web API? I have had
issues with a report table that has changed values in Relative periods for
some reason. See the copy of the Relative periods below in XML format. You
will see that all values are false but we know that when creating this
report table in Pivot table, there have to be a value with True. This means
the report table changed somehow. But I want to fix this. However, I can no
longer fix it from Pivot Tables because it wont open. It requires one value
to be true. So, how can I change this value without going to the pivot
tables? I am using DHIS2.20.
In your database, there is a table called “reporttable”, this has a column named “relativeperiodsid”, use this identifier to update the table “relativeperiods” (there you can set true/false etc as you like)
Is it possible to modify a report table through the Web API? I have had issues with a report table that has changed values in Relative periods for some reason. See the copy of the Relative periods below in XML format. You will see that all values are false but we know that when creating this report table in Pivot table, there have to be a value with True. This means the report table changed somehow. But I want to fix this. However, I can no longer fix it from Pivot Tables because it wont open. It requires one value to be true. So, how can I change this value without going to the pivot tables? I am using DHIS2.20.
Is it possible to modify a report table through the Web API? I have had issues with a report table that has changed values in Relative periods for some reason. See the copy of the Relative periods below in XML format. You will see that all values are false but we know that when creating this report table in Pivot table, there have to be a value with True. This means the report table changed somehow. But I want to fix this. However, I can no longer fix it from Pivot Tables because it wont open. It requires one value to be true. So, how can I change this value without going to the pivot tables? I am using DHIS2.20.
This is as far as I can tell, also an issue on the current version running, on play. Is this expected behavior or a bug with in the API?
Best,
Trøyel
···
Hi Morina
In your database, there is a table called “reporttable”, this has a column named “relativeperiodsid”, use this identifier to update the table “relativeperiods” (there you can set true/false etc as you like)
Is it possible to modify a report table through the Web API? I have had issues with a report table that has changed values in Relative periods for some reason. See the copy of the Relative periods below in XML format. You will see that all values are false but we know that when creating this report table in Pivot table, there have to be a value with True. This means the report table changed somehow. But I want to fix this. However, I can no longer fix it from Pivot Tables because it wont open. It requires one value to be true. So, how can I change this value without going to the pivot tables? I am using DHIS2.20.