Use a query limit to limit the number of elements displayed in a result list and in the control elements with list values (for example, menus). If the number of results exceeds the limit, a filter dialog opens.
In the Designer, you can globally define the maximum number of entries displayed before the filter dialog is opened in the Common | DBConnection | ListLimit configuration parameter. In addition, the current user can use the system setting or enter their own limit. The personal limit overwrites the global value in the configuration parameter.
To use the system settings
-
Select the Database > Settings menu item.
-
On the User tab, in the Data query limits section, set the Enable data query limits and Use system settings options.
- OR -
On the User tab, in the Data query limits section, set the Limit result list object count and Use system settings options.
This setting applies the global value defined in the Common | DBConnection | ListLimit configuration parameter.
To use a personal limit
-
Select the Database > Settings menu item.
-
On the User tab, in the Data query limits section, set the Enable query limits options.
- OR -
On the User tab, in the Data query limits section, set the Limit result list object count and Use system settings options.
-
On the User tab, in the Data query limits section, clear the Use system settings option and under Objects, specify the number of objects.
Note: The Enable query limits option can only be set if the user owns the Common_AllowRiskyWhereClauses program function.