A condition is used to filter all entries that match the specified condition according to the selected object definition.
To create a filter query using an SQL condition in the Designer
-
In the Designer, select the Filter > Manage filters menu.
-
Click New filter.
-
In the Define a filter dialog, select the SQL filter method.
-
In the Filter parameter pane, enter the following information.
-
Filter objects of: The object definition for the list is already selected.
-
Search pattern: Enter the condition. Enter the condition as a valid database query WHERE clause. You can enter the database queries as an SQL query directly or compile the database queries with a wizard. Use the Expert view and Simple view button to switch to the appropriate view.
-
-
To save the filter, enter a name and a description for the search filter in the Save filter pane and click Save.
-
(Optional) To make the filer available to all users
-
Click Publish.
-
Confirm the security prompt with Yes.
-
-
(Optional) To apply the filter immediately, click Filter.
-
Select the Database > Commit to database and click Save.