Skip to main content
kavyam0002
kavyam0002
Brainy
Apr 11, 2022 10:20 AM UTC
Question

paging

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
    Apr 11, 2022 10:38 AM UTC

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

    kavyam0002
    kavyam0002Author
    Brainy
    Apr 11, 2022 10:46 AM UTC

    Appian Community 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Apr 11, 2022 10:47 AM UTC

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

    gopalk2865
    gopalk2865
    Participating Frequently
    Apr 11, 2022 12:38 PM UTC

    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.  

    kirank0006
    Known Participant
    Apr 11, 2022 12:45 PM UTC

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

    Terms & ConditionsAccessibility statement