Try this: select * from reporttable rt inner join relativeperiods rp using (relativeperiodsid);
On Wed, Jan 25, 2017 at 11:15 AM, 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/> >> >> > -- 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
