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.
-