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
For what purpose do you try to load the whole table into memory?
I Need to show all the data into Grid in UI
I would say show few columns in the grid by minimizing the amount of data that you query and try to have a summary where you can display the whole data of that particular selection. That would be a better option. If you have too many columns your grid would look clumsy anyway. So I would consider few points from Rohit's suggestion.
Sorry, but that will never work. That will result in a slow UI and a bad UX. Besides hitting the memory restrictions of Appian.
You will have to implement that in a way you only display a certain subset of the data.
Can you share the code where you are calling this rule in the grid
In grid I am passing local data
Can you try calling rule in data keyword in grid and pass fv!paginginfo to paginginfo rule input without using local variable