A search query with an SQL condition searches all entries of the selected object definition that match the SQL condition.
To create a filter query using an SQL condition in the Manager
-
In the Manager, select the My One Identity Manager > Filters category.
-
Select the New filter context menu item.
-
In the Define a filter dialog, select the SQL filter method.
-
In the Filter parameter pane, enter the following information.
-
Filter objects of: Select the object definition in which to perform the search.
-
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 or Simple view button to switch to the appropriate view.
-
(Optional) If required, specify the following settings in the Optional parameter section.
-
Sort criteria: Specify the properties (columns) by which to sort the search result. Click to show all available properties according to the object definition. Click on a name to transfer the entry to the input field.
-
Display template: Specify the format in which the results are displayed. Click to show all available properties according to the object definition. Click on a name to transfer the entry to the input field.
-
In the Save filter section, enter a name and description for the search filter.
-
To save the filter, click Save.
-
(Optional) To make the filer available to all users
-
Click Publish.
-
Confirm the security prompt with Yes.
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 Manager using the full-text search
-
In the Manager, select the My One Identity Manager > Filters category.
-
Select the New filter context menu item.
-
In the Define a filter dialog, select the Full text filter method.
-
In the Filter parameter pane, enter the following information.
-
Filter objects of: Select the object definition in which to perform the search.
-
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.
-
(Optional) If required, specify the following settings in the Optional parameter section.
-
Sort criteria: Specify the properties (columns) by which to sort the search result. Click to show all available properties according to the object definition. Click on a name to transfer the entry to the input field.
-
Display template: Specify the format in which the results are displayed. Click to show all available properties according to the object definition. Click on a name to transfer the entry to the input field.
-
In the Save filter section, enter a name and description for the search filter.
-
(Optional) To make the filer available to all users
-
Click Publish.
-
Confirm the security prompt with Yes.
-
To save the filter, click Save.
To use a filter in the Manager
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 Manager
-
In the Manager, select the filter in the My One Identity Manager > Filters category.
-
Select the Edit filter context menu item.
-
Click Publish.
-
Confirm the security prompt with Yes.
-
Click Save.