Hi, the issue is batch size in the paging.. count[no of rows] is miss matching..
when i give the batch size =-1 then count[no of rows] will match to db data
when i give the batch size =10 or 1 or 20 or 50 whatever it will miss match the count[no of rows] from db to UI
why this will happen! what is the exact issue? why batch size is giving issue?
can anyone help me with this
Discussion posts and replies are publicly visible
Do you have any code snippets or error messages? And what do you want to achieve? What is "count"?
Appian Community
OK. What do you mean with "count no of rows"? TotalCount? Rows returned?
what batchsize parameter will do?
batch size parameter will return the no of items/ total items from the db
I do not really understand the issue. The batchsize defines the number of rows in the returned dataset.
StartIndex and batchSize translate to offset and limit in SQL.
www.mariadbtutorial.com/.../
Start Index tells you from which row to start. Batch size tells you the number of rows from the start index.