dhis2-users team mailing list archive

[Morina Matasi <morena.motsieng@xxxxxxxxx>]

> 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@xxxxxxxxx
> > 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@xxxxxxxxxxxxxxxxxxx
>> 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
> lars@xxxxxxxxx
> http://www.dhis2.org <https://www.dhis2.org/>
>
>