A search query using placeholders searches for the search pattern in the display values of the selected object definition.
To run a simple database search in the Manager with placeholders
-
In the Manager, select the View > Database search menu item.
The database search is displayed in the navigation view.
-
Enter the following information in the Search section.
-
Search in: Select the object definition. All object definitions in the currently selected category are displayed.
-
Search text: Enter the search term. You can use * as a wildcard. Case sensitivity is not taken into account.
Examples:
Pattern or 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
-
Full-text search: Disable the option.
-
Start the search using the Search button.
TIP: Press 
to set the current query as the default for future search queries.
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 run a simple database search in the Manager as a full-text search
-
In the Manager, select the View > Database search menu item.
The database search is displayed in the navigation view.
-
Enter the following information in the Search section.
-
Search in: Select the object definition. All object definitions in the currently selected category are displayed.
-
Search text: Enter the search term. The use of wild cards is permitted. For examples, refer to Rules and examples for the full-text search.
-
Full-text search: enable the option.
-
Start the search using the Search button.
TIP: Press to set the current query as the default for future search queries.
Related topics
The advanced database search allows 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
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
A search query using wildcards searches for the search pattern in the display values of the selected object definition.
To create a filter query using wildcards in the Manager
-
In the Manager, select the View > Database search menu item.
The database search is displayed in the navigation view.
-
To open the advanced database search, click the Advanced button in the Search section.
-
Click New search and select the Wildcard search method.
-
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 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.
-
To save the search, enter a name and a description for the search filter in the Save search pane and click Save.
