Can someone help with example. How to do batching in Query.
I have clear understanding of how it works but need clarity while implementing.
Eg: create a query entity rule such as : a!queryEntity(entity: cons!entity, query: a!query(filters{whatever filters you want},local!pagingInfo(startIndex: 1, batchSize: 100)))after this what i need to do?
I need to fetch 7000 records
Discussion posts and replies are publicly visible
https://docs.appian.com/suite/help/23.3/configure-record-data-source.html#syncing-in-batches
a!localVariables( local!batchSize: 100, local!startIndex: 1 + ((ri!batchNumber - 1) * local!batchSize), a!queryRecordType( recordType: 'recordType!{SYSTEM_RECORD_TYPE_USER}User', pagingInfo: a!pagingInfo(local!startIndex, local!batchSize) ) )
For what purpose do you want to load 7000 records into memory? In general, this is a bad practice and not recommended!
I totally agree with your point but when you are working on already built Application which is live, we cannot go ahead and follow all the best practice and latest features all of a sudden, we need to first make changes to existing code and make the Application work as expected.
So if you have solution to my question that will help me.