Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
7 replies
Subscribers
7 subscribers
Views
5571 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
batching the query
rohandhondilalk401
over 7 years ago
Hi,
I want to know how does exactly batching the query will work in Appian in retrieve the larger data ?
OriginalPostID-256157
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 7 years ago
@rohandhondilalk Let's say you would like to retrieve 'x' records at a time. Batch size will be always equal to 'x' and is fixed. Whereas the start index varies across each batch as 1 for the first batch, 1+x for the second batch, 1+(2x) for the third batch, 1+(3x) for the fourth batch and so on. A fixed batch size, a varying start index across each batch, and fn!ceiling(totalCount of query rule or entity/x) number of batches(or iterations) should help you accomplish retrieving the records in batches.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 7 years ago
@rohandhondilalk Let's say you would like to retrieve 'x' records at a time. Batch size will be always equal to 'x' and is fixed. Whereas the start index varies across each batch as 1 for the first batch, 1+x for the second batch, 1+(2x) for the third batch, 1+(3x) for the fourth batch and so on. A fixed batch size, a varying start index across each batch, and fn!ceiling(totalCount of query rule or entity/x) number of batches(or iterations) should help you accomplish retrieving the records in batches.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data