I want batching for looping process suppose i have 1000 id's and i want to execute loop with 200 batchsize.
a!forEach( items: local!id, expression:fvi!item
)
Discussion posts and replies are publicly visible
Can you give us a bit more background?
codeblog.jonskeet.uk/.../
Hi Yogesh,
Are you planning to use queryEntity in loop?
Hello Stefan, I have a similar issue. I want to run a process model but I want to write the data to database in batches of 10-20.
Did you read this?
https://docs.appian.com/suite/help/23.2/looping.html
https://docs.appian.com/suite/help/23.2/looping.html#how-to-build-a-loop-flow-in-a-process-model
You can build a loop in a process model with the help of an integer variable and an XOR. Keep incrementing the variable until you reach the total count. But what is the use case of writing the data in batches instead of all at once?
actually, we need to reduce transaction calls and the load on the process.AFAIK, using a variable and an XOR will increase the transaction calls, and writing the data all at once will increase the load.
That's why we need to do it in batches.
Using XOR won't increase the calls. Why do you think it will? Also, I suggested you a way to batch the data. You can implement to batch.