Issue with /api/reportTables api

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

Inline image 1

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

DHIS_reportTable_api_data (2.04 KB)

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)

image

···

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.


Morten

Hm, I take that back… seems both are included… seems strange

image

···

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

I checked in play.dhis2.org also. I am seeing the same issue.
For the reportTable, “ANC: Coverages Quarterly” last row data is not being retrieved by the api

https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

Is it a known issue?

image

···

On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, I take that back… seems both are included… seems strange


Morten

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

Seems relative periods are rewinded by one period. “This quarter” returns Apr-Jun in the pivot table, but Jan-Mar in /data.html. Should be fixed.

image

···

On 12 April 2016 at 11:06, Aamer Mohammed aamerm@thoughtworks.com wrote:

I checked in play.dhis2.org also. I am seeing the same issue.
For the reportTable, “ANC: Coverages Quarterly” last row data is not being retrieved by the api

https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

Is it a known issue?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, I take that back… seems both are included… seems strange


Morten

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

Hi Aamer,

this seems to work as expected in 2.22 / on demo. Can you try to reproduce there? If not, can you upgrade to 2.22?

regards,

Lars

image

···

On Tue, Apr 12, 2016 at 4:54 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Seems relative periods are rewinded by one period. “This quarter” returns Apr-Jun in the pivot table, but Jan-Mar in /data.html. Should be fixed.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On 12 April 2016 at 11:06, Aamer Mohammed aamerm@thoughtworks.com wrote:

I checked in play.dhis2.org also. I am seeing the same issue.
For the reportTable, “ANC: Coverages Quarterly” last row data is not being retrieved by the api

https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

Is it a known issue?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, I take that back… seems both are included… seems strange


Morten

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Lars,

I checked on demo (Version 2.22, Revision 21999). The reportTable ‘ANC Coverages Quarterly’ has below data

Inline image 1

Whereas the api https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

is not giving the same data. Could you please check and confirm.

Thanks

Aamer.

api_data.json (2.55 KB)

···

On Fri, Apr 15, 2016 at 8:20 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Aamer,

this seems to work as expected in 2.22 / on demo. Can you try to reproduce there? If not, can you upgrade to 2.22?

regards,

Lars

On Tue, Apr 12, 2016 at 4:54 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Seems relative periods are rewinded by one period. “This quarter” returns Apr-Jun in the pivot table, but Jan-Mar in /data.html. Should be fixed.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On 12 April 2016 at 11:06, Aamer Mohammed aamerm@thoughtworks.com wrote:

I checked in play.dhis2.org also. I am seeing the same issue.
For the reportTable, “ANC: Coverages Quarterly” last row data is not being retrieved by the api

https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

Is it a known issue?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, I take that back… seems both are included… seems strange


Morten

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

Okay now I see what you mean.

Fixed now in trunk and 2.22.

regards,

Lars

image

image

···

On Mon, Apr 18, 2016 at 1:36 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Lars,

I checked on demo (Version 2.22, Revision 21999). The reportTable ‘ANC Coverages Quarterly’ has below data

Whereas the api https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

is not giving the same data. Could you please check and confirm.

Thanks

Aamer.

On Fri, Apr 15, 2016 at 8:20 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Aamer,

this seems to work as expected in 2.22 / on demo. Can you try to reproduce there? If not, can you upgrade to 2.22?

regards,

Lars

On Tue, Apr 12, 2016 at 4:54 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Seems relative periods are rewinded by one period. “This quarter” returns Apr-Jun in the pivot table, but Jan-Mar in /data.html. Should be fixed.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On 12 April 2016 at 11:06, Aamer Mohammed aamerm@thoughtworks.com wrote:

I checked in play.dhis2.org also. I am seeing the same issue.
For the reportTable, “ANC: Coverages Quarterly” last row data is not being retrieved by the api

https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

Is it a known issue?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, I take that back… seems both are included… seems strange


Morten

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

Hi Lars,

Thanks for the quick fix. Could you backport it to 2.21 as well.

Thanks

Aamer.

image

image

···

On Mon, Apr 18, 2016 at 5:48 PM, Lars Helge Øverland lars@dhis2.org wrote:

Okay now I see what you mean.

Fixed now in trunk and 2.22.

regards,

Lars

On Mon, Apr 18, 2016 at 1:36 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Lars,

I checked on demo (Version 2.22, Revision 21999). The reportTable ‘ANC Coverages Quarterly’ has below data

Whereas the api https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

is not giving the same data. Could you please check and confirm.

Thanks

Aamer.


Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On Fri, Apr 15, 2016 at 8:20 PM, Lars Helge Øverland lars@dhis2.org wrote:

Hi Aamer,

this seems to work as expected in 2.22 / on demo. Can you try to reproduce there? If not, can you upgrade to 2.22?

regards,

Lars

On Tue, Apr 12, 2016 at 4:54 PM, Jan Henrik Øverland janhenrik.overland@gmail.com wrote:

Seems relative periods are rewinded by one period. “This quarter” returns Apr-Jun in the pivot table, but Jan-Mar in /data.html. Should be fixed.


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

http://www.dhis2.org

On 12 April 2016 at 11:06, Aamer Mohammed aamerm@thoughtworks.com wrote:

I checked in play.dhis2.org also. I am seeing the same issue.
For the reportTable, “ANC: Coverages Quarterly” last row data is not being retrieved by the api

https://play.dhis2.org/demo/api/reportTables/C0rhAq1oklh/data.json

Is it a known issue?


Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

On Tue, Apr 12, 2016 at 1:00 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, I take that back… seems both are included… seems strange


Morten

On Tue, Apr 12, 2016 at 2:29 PM, Morten Olav Hansen morten@dhis2.org wrote:

Hm, seems March 2015 is included instead of March 2016… not sure if it’s a known issue or not, but seems like a bug, Lars will know better (maybe it’s fixed already)


Morten

On Tue, Apr 12, 2016 at 2:27 PM, Aamer Mohammed aamerm@thoughtworks.com wrote:

Hi Devs,

We have seen the below issue when working with /api/reportTables api. We are using DHIS 2.21 build revision 21058.

The reportTable as seen in DHIS app is as below.

However when we try to fetch the data for the same report Table through /api/reportTables//data.html api we are not getting entire data. The data for last row is not retrieved through api (json response attached)

Is anyone else facing this issue? Any observations please.

Thanks

Aamer.