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
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.