Chat now with support
Chat with Support

Identity Manager 8.1.4 - User Guide for One Identity Manager Tools User Interface

About this guide One Identity Manager tools user interface
The user interface layout Using the help in the Manager Status bar information Current user Menu items in the Manager Views in the Manager Manager program settings Reloading modifications to the user interface Detailed information about the user interface Limiting list entries using the list limit Limiting list sizes using simple filters Searching for list entries User-defined filters in the Manager Database search in the Manager Displaying advanced properties of an object Multiple object edit in the Manager Committing data on change conflicts
Working with the Designer

User-defined filters in the Manager

You make use of user-defined filters if you wish to run specific search queries frequently. 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 a 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

Creating a filter query using placeholders

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

  1. In the Manager, select the My One Identity Manager | My filters category.

  2. Click the New filter context menu and select the Wildcard filter method.

  3. 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 search pattern. Use of wild cards * in the search pattern is permitted.

      Example:

      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

  4. (Optional) If required, specify the following settings in the Optional parameter area.

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

  5. To save the filter, enter a name and a description for the search filter in the Save filter area and click Save.

Creating a filter query using a SQL condition

A search query with a SQL condition searches all entries of the selected object definition that match the SQL condition.

To create a filter query using a SQL condition in the Manager

  1. In the Manager, select the My One Identity Manager | My filters category.

  2. Click the New filter context menu and select the SQL filter method.

  3. 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 WHERE clause for a database query. You can enter the database queries as a 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.

  4. (Optional) If required, specify the following settings in the Optional parameter area.

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

  5. To save the filter, enter a name and a description for the search filter in the Save filter area and click Save.

Creating a filter query using the full-text search

NOTE: To use the full-text search, you must run the program over an application server with an installed search service. For detailed 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 detailed 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

  1. In the Manager, select the My One Identity Manager | My filters category.

  2. Click the New filter context menu and select the Full text filter method.

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

  4. (Optional) If required, specify the following settings in the Optional parameter area.

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

  5. To save the filter, enter a name and a description for the search filter in the Save filter area and click Save.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating