Want To fetch the data more than 5000 . let me know how to fetchrule!PPO_qrtName( pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 7000) ).data,
Discussion posts and replies are publicly visible
Instead of specifying a large batch size, use a loop to iterate through the data in smaller batches. You can achieve this using the forEach function within your expression rule. Inside the loop, handle the retrieved data in each batch. You can store the data in a temporary variable, perform necessary operations, and potentially accumulate results across iterations.
forEach
i dont think we can apply batching in query record type . can u pls provide an example
We can Apply . Refer to this
Yes, you can... using pagingInfo, set the first record to the last record of the previosus query +1
a!localVariables( local!batchSize: 5000, local!totalCount: index( a!queryRecordType( recordType: /*Put your record here*/, pagingInfo: a!pagingInfo(1, 1) ), "totalCount", {} ), local!maxNumberBatch: ceiling(local!totalCount / local!batchSize), local!enumeratedIndex: enumerate(local!maxNumberBatch) + 1, a!flatten( a!forEach( items: local!enumeratedIndex, expression: a!flatten( a!queryRecordType( recordType:/*Put your record here*/, pagingInfo: a!pagingInfo( 1 + ((fv!index - 1) * local!batchSize), local!batchSize ) ).data ) ) ) )