dhis2-users team mailing list archive

[Lars Helge Øverland <lars@xxxxxxxxx>]

Try this:

select * from reporttable rt
inner join relativeperiods rp using (relativeperiodsid);

​

On Wed, Jan 25, 2017 at 11:15 AM, Morina Matasi <morena.motsieng@xxxxxxxxx>
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.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/>
>>
>>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>