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.