dhis2-users team mailing list archive

[Trøyel Nerbø <troyel.nerbo@xxxxxx>]

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.no@xxxxxxxxxxxxxxxxxxx] On Behalf Of Morten Olav Hansen
Sent: onsdag 25. januar 2017 11.19
To: Morina Matasi <morena.motsieng@xxxxxxxxx>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx
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.motsieng@xxxxxxxxx<mailto: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<mailto: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<mailto: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<mailto:lars@xxxxxxxxx>
http://www.dhis2.org<https://www.dhis2.org/>



_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp