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.
You can use the filter dialog to limit the entries in a list though defined filter criteria. A filter remains in use until you reset it. Settings in the filter dialog are saved in the user configuration.
If you want to start certain search queries more frequently, create search queries for the advanced database search or create user-defined filters.
To limit a result set
-
In Filter condition, enter the text to use as a basis for filtering. Use of * as wild cards is permitted. Case sensitivity is not taken into account.
-
In Apply to, enable the properties to which the filter condition is to be applied.
-
If you only want lists to show objects that meet the filter condition and are already assigned to the base object, enable the Only show current assignment option.
NOTE: This option is only available for lists with object assignments.
-
Click Apply.
NOTE: To display all objects, click Show all. The filter condition is not applied in this case.
Example:
This filter condition is used to search for all parts of an identity’s full name. This is put together in the following manner:
Full name
Example:
Miller, Alex
Miller-Meyer, Dani
Meyer-Miller, Chris
|
Miller or *Miller* |
Finds all identities whose full name contains the string Miller. |
Miller, Alex
Miller-Meyer, Dani
Meyer-Miller, Chris |
|
Miller* |
Finds all identities whose full name begins with the string Miller. |
Miller, Alex
Miller-Meyer, Dani |
|
*Miller |
Finds all identities whose full name ends with the string Miller. |
No entry |
Use the search dialog to search for entries within a list.
To search in a list
-
Open the search dialog from the Search context menu, by clicking the 
icon or with the shortcut Ctrl + F.
-
Enter the Search term or select a previous one from the list using the arrow button.
-
Set the Case sensitive option if required.
-
Start the search with the Search or Enter button.
-
Use F3 to continue searching.
-
End the search with Esc.
Table 33: Shortcuts for the search dialog
|
Ctrl + F |
Open search dialog. |
|
Data |
Start search. |
|
Esc |
End search. |
|
F3 |
Search next. |
For a wider ranging search, use the database search function.
You make use of user-defined filters if you wish to run specific search queries frequently. You can create your own (private) filters or public filters.
User-defined filters allow you to run the following searches:
Detailed information about this topic
