Skip to main content
kavyam0002
kavyam0002
April 11, 2022
Question

paging

  • April 11, 2022
  • 8 replies
  • 0 views

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 

    8 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    April 11, 2022

    Do you have any code snippets or error messages? And what do you want to achieve? What is "count"?

    kavyam0002
    kavyam0002Author
    April 11, 2022

    Appian Community 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    April 11, 2022

    OK. What do you mean with "count no of rows"? TotalCount? Rows returned?

    gopalk2865
    gopalk2865
    Participating Frequently
    April 11, 2022

    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.  

    K
    kirank0006
    April 11, 2022

    If you want only Totalcount of rows form db table then provide batchsize as 0.

    Terms & ConditionsAccessibility statement