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> 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> 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 >>> 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 >> http://www.dhis2.org <https://www.dhis2.org/> >> >> > > _______________________________________________ > 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 > >
_______________________________________________ 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
