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 From: Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf Of Morten Olav Hansen Sent: onsdag 25. januar 2017 11.19 To: Morina Matasi <morena.motsi...@gmail.com> Cc: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Modify Report Table via Web API? 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) -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Wed, Jan 25, 2017 at 5:15 PM, Morina Matasi <morena.motsi...@gmail.com<mailto:morena.motsi...@gmail.com>> wrote: 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.motsi...@gmail.com<mailto:morena.motsi...@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. <relativePeriods> <lastWeek>false</lastWeek> <lastQuarter>false</lastQuarter> <monthsThisYear>false</monthsThisYear> <last5FinancialYears>false</last5FinancialYears> <last2SixMonths>false</last2SixMonths> <monthsLastYear>false</monthsLastYear> <last6BiMonths>false</last6BiMonths> <last12Months>false</last12Months> <last12Weeks>false</last12Weeks> <thisYear>false</thisYear> <lastFinancialYear>false</lastFinancialYear> <last4Weeks>false</last4Weeks> <lastSixMonth>false</lastSixMonth> <thisMonth>false</thisMonth> <lastMonth>false</lastMonth> <last6Months>false</last6Months> <thisFinancialYear>false</thisFinancialYear> <lastBimonth>false</lastBimonth> <thisWeek>false</thisWeek> <last3Months>false</last3Months> <quartersLastYear>false</quartersLastYear> <thisSixMonth>false</thisSixMonth> <thisQuarter>false</thisQuarter> <last4Quarters>false</last4Quarters> <thisBimonth>false</thisBimonth> <quartersThisYear>false</quartersThisYear> <lastYear>false</lastYear> <last52Weeks>false</last52Weeks> <last5Years>false</last5Years> </relativePeriods> _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland l...@dhis2.org<mailto:l...@dhis2.org> http://www.dhis2.org<https://www.dhis2.org/> _______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net<mailto:dhis2-users@lists.launchpad.net> Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
