Calling expression data in batches

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

Parents
  • 0
    Certified Senior Developer

    Hello   

    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.

Reply
  • 0
    Certified Senior Developer

    Hello   

    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.

Children
No Data