Limit number of records to be displayed in the Grid

To limit the number of records to be displayed, we will use the Limit function within the query where they bring the data of a certain table.

For example in this way:

Then only 5 records are shown:

• Related Articles

• How to edit records from a capture link.

  In this article, see how to create a binding to edit a record from a grid used in a capture binding. We cannot use the edit link in this case, as the edit button will not be available when we access the grid to capture a value. Taking into account ...

• Email Export in Grid

  In the Query applications, you can configure the email export. This feature is used to export the Grid and send the export directly by e-mail to the configured recipients. E-mail export settings can be visualized in the Email export menu. Next, you ...

• Using tags in the grid search

  When we are using the search in the Grid applications, we can enable the display of the tags for the searched values. This option can be adjusted in the Advanced Search settings. Enable the option Display tags. Then run the application and access the ...

• Using inline buttons in the Advanced Grid Search

  When you are using the advanced filter in Grids you can configure the button display mode. In order to do this, you must access the Advanced Search toolbar, as shown below. On the toolbar configuration screen, enable the Use buttons inline option. ...

• Change the charset to view the records.

  When an error appears in the charset of the special characters as in the image below: This happens when the database charset and the script case charset are not the same but we can no longer edit it in the database. We use the following code in the ...