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 a 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 a 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 > Save to database and click Save. 
