Issue with pagination

Question

I'm facing an issue with task report it displaying in grid with pagination and custom filters so once i'm filtering some particular data, it's working fine but my issue is upto 21 pages pagination filtering data in grid is working as i'm expected but after 22th page onward filtering is not working.

Martin Camacho · Accepted Answer

Try reseting the startindex to 1 everytime you query the report, 
 
a!save( 
 ri!pagingInfo.startIndex, 
 1 
)

ganeshbabuj · Answer

Are u filtering on start Date and then navigating to next page? IF yes, which version of Appian are you on? 
 
IF Version is 17+ , then add second field for sorting and then try . it will start working.

legotx · Answer

You need to use the same a!pagingInfo parameter from your query to your grid. Otherwise it becomes unsynchronized. Additionally, if you perform another search, your a!pagingInfo startIndex must be reset.

aloks0189 · Answer

Hi deviratnamv if i understood your query correctly, your data is not getting refreshed while you are switching to next page when your filters are applied. 
 If so, then i suspect the following as the root cause behind this issue: 
 
 You are not refreshing your pagination i.e. the variable which holds a!pagingInfo, you need to configure this under value and saveInto of your gridField. 
 You are not refreshing the data which comes from a!queryProcessAnalytics() upon updating your pagingInfo, you can do this in two ways:

Either by calling your rule / expression inside with() or 
 Explicitly using saveInto to reload the local variable (which holds the datasubset/resultant data) to refresh it's content. 
 
 NOTE: Don't forget to pass your filter criteria to your rule, where if filter is null then {} else only fetch the required rows. 
 For better clarification, i would recommend, sharing your code snippet here so that it will be easy to make the correction.