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.
Related topics
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 > Commit to database and click Save.
Related topics
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.
Related topics
NOTE: To create, edit, and delete public filters, the user requires the Option to define, modify, and delete public filters. program function. (Common_PublicFilterDefine).
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 > Commit to database and click Save.
Related topics