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 > Save to database and click Save.
NOTE: To use the full-text search, you must run the program over an application server with an installed search service. For more information about installing an application server for full-text search, see the One Identity Manager Installation Guide.
A search query using full-text search, searches for the specified search term in all columns of the selected object definition that are indexed for full-text search. For more information about configuring columns for the full-text search, see the One Identity Manager Configuration Guide.
To create a filter query in the Designer using the full-text search
-
In the Designer, select the Filter > Manage filters menu.
-
Click New filter.
-
In the Define a filter dialog, select the Full text filter method.
-
In the Filter parameter pane, enter the following information.
-
Filter objects of: The object definition for the list is already selected.
-
Search string: Enter the search term. The use of wild cards is permitted. For examples, refer to Rules and examples for the full-text search.
-
In the Save filter pane, enter a name and a description for the search filter 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.
To use a saved filter in the Designer
-
In the Designer, select the Filter > Manage filters menu.
-
Double-click the search filter in the Saved filters pane.
-
Click Filter.
NOTE: To create, edit, and delete public filters, users require the Common_PublicFilterDefine program function.
You can make filters available to all users by publishing them. You have the option to publish a filter when you create it. Afterward, you can also publish a private filter.
To publish a filter in the Designer
-
In the Designer, select the Filter > Manage filters menu.
-
Double-click the search filter in the Saved filters area.
-
Click Publish.
-
Confirm the security prompt with Yes.
-
Select the Database > Save to database and click Save.