• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 36 replies
  • Subscribers 4 subscribers
  • Views 6541 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Clicking on the last page/record returns an error attached.

vinitl522
A Score Level 2

Hello All,

I have created a Portal All task report, and then created a tempo report of that Portal report using a!queryProcessAnalytics. All the filters and pagination is working fine, but when I click on to get the last page/record then it returns an error attached.

Let me know what could be the error, is it something to do with Engine, which is not able to fetch the last page.

Note: The task report has nearly 20000 rows.

Regards,
Vinit.

Portal Report Error.docx

OriginalPostID-155336

OriginalPostID-155336

  Discussion posts and replies are publicly visible

Parents
  • 0
    @vinitl Yes, 1) A original report and 2) A report which consists of data same as in the original report but additionally grouped by year, month and day. Apply a!queryProcessAnalytics() iteratively with source as report (1) and filter as each record in report(2). This is the approach to devised by us to trespass the limit and we have been successful. FYI, we are able to extract 100000+ records of analytics data using a!queryProcessAnalytics() in 1 minute.
Reply
  • 0
    @vinitl Yes, 1) A original report and 2) A report which consists of data same as in the original report but additionally grouped by year, month and day. Apply a!queryProcessAnalytics() iteratively with source as report (1) and filter as each record in report(2). This is the approach to devised by us to trespass the limit and we have been successful. FYI, we are able to extract 100000+ records of analytics data using a!queryProcessAnalytics() in 1 minute.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.