Facing issue in expression while querying the data

Certified Associate Developer

Hi Team,

While querying the data from database I am Geeting error msg like 



I have given batch size 1, -1y, I want to retrieve all data from database view table(6500 rows)

Can you please help me on this.

Thanks,

Nag  

  Discussion posts and replies are publicly visible

  • Use Appian record to create the grid and Appian will automatically solve the batch size issue for you.

    Alternatively, if you are pulling data in a local variable first and use that to render the grid then make sure the query of local variable and paging grid shares the same paging info. This way you will only pull the rows needs to display in one page of grid and limits the batch size.