How can I change the number of items displayed on a page in Interactive grid?

When execute a SQL query, it return 14 records. And all of them are displayed on the first page. I want to display 5 items on each page. Can this problem be solved by changing any settings?

CodePudding user response：

• navigate to interactive grid's Attributes
• under the "Pagination" property, set
  • Type: Page
    • because, if it is set to "Scroll" - which is the default - you can't do what you want
• run the page
• go to the "Actions" button >> Format >> Rows per page
  • choose value you want (5, right?)