Is there any more info available on how Paginginfo works within Appian ?
I've an upcoming use case where we will have a source of truth table which over time will become quite large. We will be doing all the user tricks to keep it responsive but at some point we will be querying it and no matter how many filters etc we get returned the data subset will be for a large amount of records. (let pretend 10,000).
i'll use pagingInfo to control the grid, but whilst I'm displaying records 1 to 100, what is happening to the rest of the data set ? I'm assuming it's floating around in Appian memory somewhere.
I'm interested in people's thoughts here ?
Discussion posts and replies are publicly visible
Richard, It is very clear and to the point. Thank you! For some reason on my page, the paging grid is behaving bizarre! I am retrieving the grid data in a WITH clause and the paging info is a local variable in LOAD. The grid data changes based on changing user-selected filter values so the WITH is working as expected but the TOTAL records retrieved is always equal to the BATCH SIZE. If I don't specify a page size then the page size defaults to 10 otherwise, it defaults to whatever I specify the page size to be. I thought the batch size would determine the page size as we go through the pagination. What am I missing? I am using 19.4.
© 2022 Appian. All rights reserved.