While querying the Entity whatever the first Start index (startindex:1, Batch Size: 20) mentioning up to that only i was able to get the data.
When i am trying to increasing the start index > 1 (startindex:21, Batch Size: 20) getting the below error
Errors in Expression: Expression evaluation error at function a!queryEntity: An error occurred while retrieving the data. Details: Unexpected error executing query (type: [COTAAuditRequestRDT14171], query: [queryentity expression], order by: [[Sort[request_id asc]]], filters:[null])
Discussion posts and replies are publicly visible
In your screenshot I see that your first call already takes almost 8 seconds. I expect that the second one runs into a timeout. Is that a view your try to query?
Yes it is a View
Then this is a timeout issue and you need to drastically improve the performance of your view.
Thank you for the Reply
Could you please suggest won't be there any other option to fix this in the Appian itself apart from view.
You cannot fix a slow view from Appian.
community.appian.com/.../database-performance-best-practices
Thanks for the Reply. Will work on it