Hi All, I am calling the data from db through expression rules and gave batch size as 100. I need to use this data in interface inside grid, is this only 100 records will be displayed in interface or I can display whole data from table.
Discussion posts and replies are publicly visible
What exactly is your question? What requirement do you have and what trouble are you having fulfilling it? What have you already tried and found not to work as expected?
Rahul009 said:or I can display whole data from table.
No, you do not want to show the whole database table in a grid.
Hello Rahul009
Since you are using the expression rule for your grid's data source, whatever batch size you have configured in the query will be the number of rows you will be able to display in the grid. Also your pageSize parameter in the grid will define the number of rows to be displayed in the current page. Also If you want all the records in the grid you can use the recordData() for the data parameter in the grid instead of your expression rule. Do not show all the rows in a single page, It would not be a good user experience.
You can use batch size as -1 to pull all the rows from the table and use it to display in the grid.
But it is strictly not advisable keeping the SAIL performance in mind
See the Paging section of Read-Only Grid documentation to get more ideas. There are multiple ways like grid-managed paging, direct query, query using an expression rule, etc.
https://docs.appian.com/suite/help/24.3/read-only-grid-configuration.html#paging-and-sorting