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.
Hi Kavya, don't compare the select query from SQL statement with query entity in Appian. When you provide batch size ,then it means you are specifying the number of rows to be returned. If you provide batch size as -1 ,it means you want to return all rows from db in one go.
If you want only Totalcount of rows form db table then provide batchsize as 0.