Chat now with support
Chat with Support

Identity Manager 9.3 - 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 in the Manager Current user Changing the password of the logged in user Menu items in the Manager Layout mode in the Manager Views in the Manager Features in the navigation view Functions in the result list Features in the task view Features in the favorites list Features of the document view Overview forms Mandatory input fields Labeling changed data Translating input Displaying columns names List of permitted values Entering multiple values Setting values with the slider Entering scripts Entering database queries Entering custom filter conditions Selecting values from lists Selecting dynamic entries Selecting dates Editing login times Layout of object relations Displaying assignments General control key combinations Manager program settings Reloading changes to the user interface Detailed information about the user interface Limiting items in a list using query limits Limiting list sizes using simple filters Searching for list entries User-defined filters in the Manager Database search in the Manager Displaying extended properties for objects Multiple object edit in the Manager Committing data on change conflicts
Working with the Designer

Advanced database search

The advanced database search allows you to run the following searches:

  • 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

TIP: The saved search queries are displayed in the Manager in the My One Identity Manager > Filters category. You can run or edit the search queries there or export them for other users.

Detailed information about this topic

Creating search queries using SQL conditions

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

  1. In the Manager, select the View > Database search menu item.

    The database search is displayed in the navigation view.

  2. To open the advanced database search, click the Advanced button in the Search section.

  3. Click New search and select the SQL search method.

  4. In the Search parameter pane, enter the following information.

    • Search in: 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.

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

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

Creating search queries using 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 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 search query in the Manager using the full-text search

  1. In the Manager, select the View > Database search menu item.

    The database search is displayed in the navigation view.

  2. To open the advanced database search, click the Advanced button in the Search area.

  3. Click New search and select the Full text search method.

  4. In the Search parameter pane, enter the following information.

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

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

Rules and examples for the full-text search

The following table lists rules and examples for full-text search.

Table 34: Rules with examples for searching
Example Description

Alex Miller

Finds Alex Miller, but not Alex Meyer.

Search results must contain all of the separate terms in the query. A logical AND is used.

Alex OR Miller

Find Alex Miller and Alex Meyer.

Placing OR between the search terms, acts as a logical OR operator. The result of this search contain at least one of the two search terms.

Alex NOT Miller

Find Alex Meyer, but not Alex Miller.

The results of this search do not contain the term that comes after NOT.

Ale*

Finds Alex and Alexis.

The * functions as a wildcard for any number of characters to complete the term.

Ale?

Finds Alex, but not Alexis.

The ? functions as a wildcard for a single character to complete the term.

"Alex Miller"

Finds results in which the search terms Alex and Miller follow one another.

Results of this search contain the string in quotes as phrase.

Alex Miller~

Finds Alex Miller among others, but also similar results are shown. A tilde ~ after the search term indicates that the search should also find similar results. This means that incorrectly spelled terms can be found, as well.

You can specify the level of similarity by adding a number between 0 and 1 (with decimal point) after the tilde ~. The higher the number, the more similar the results.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating