You make use of user-defined filters if you wish to run specific search queries frequently. You can create your own (private) filters or public filters.
User-defined filters allow you to run the following searches:
-
Searching for a search term with placeholders within the display values of the selected object definition
-
Searching entries with an SQL condition
-
Searching for a search term across all columns of an object definition that are indexed for the full-text search
Detailed information about this topic
A search query using placeholders searches for the search pattern in the display values of the selected object definition.
To create a filter query using placeholders 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 Wildcard 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 search pattern. You can use * as a wildcard in the search pattern.
Examples:
Pattern* - searches for all entries whose display value starts with the Pattern string
*Pattern - searches for all entries whose display value ends with the Pattern string
*Pattern* - searches for all entries whose display value contains the Pattern string
Pattern - searches for all entries whose display value matches the Pattern string
-
(Optional) If required, specify the following settings in the Optional parameter pane.
-
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.
Related topics
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.
-
(Optional) To make the filer available to all users
-
Click Publish.
-
Confirm the security prompt with Yes.
-
To save the filter, 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 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.
Related topics
