In the Manager, you can run a simple database search or an advanced database search. Run a simple database search once. You cannot save a simple database search. Use an advanced database search if you wish to run specific search queries frequently. You can save the search query.
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
Working with the Designer
User settings in the Manager
General program settings in the Manager
Plug-ins available in the Manager
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
Creating filter queries in the Manager using SQL conditions
Creating filter queries using full-text search in the Manager
Applying filters in the Manager
Publishing filters in the Manager
Exporting and importing filters in the Manager
Attaching filters in the Manager
Editing filters in the Manager
Deleting filters in the Manager
Database search in the Manager
Simple database search
Displaying extended properties for objects
Multiple object edit in the Manager
Committing data on change conflicts
Running simple database searches using wildcards
Running simple database searches using full-text search
Advanced database search
General tips for the Designer
Menu items in the Designer
Using the help in the Designer
Views in the Designer
Designer program settings
Logging and committing objects in the Designer
Designer-internal full-text search
User-defined filters in the Designer
Using Adhoc filters in the Designer
Creating filter queries in the Designer using SQL conditions
Creating filter queries using full-text search in the Designer
Applying filters in the Designer
Publishing filters in the Designer
The editors in the Designer
Working with the Object Editor
Working with the List Editor
List Editor menu items
Functions in the List Editor result list
Configuring columns for List Editor result lists
Multiple editing of list entries in the List Editor
Displaying object relations in the List Editor
Working with the SQL Editor
Database search in the Manager
Simple database search
The simple 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 for a search term across all columns of an object definition that are indexed for the full-text search
Detailed information about this topic
Running simple database searches using wildcards
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.
-
-
(Optional) Click the Search drop-down arrow to access the Default search operator drop-down and select a search operator to use by default in the simple search. Permitted values are starts with, contains or equals.
-
Start the search using the Search button.
TIP: Press 
Related topics
Running simple database searches 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 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.
-
-
(Optional) Click the Search drop-down arrow to access the Default search operator drop-down and select a search operator to use by default in the simple search. Permitted values are starts with, contains or equals.
-
Start the search using the Search button.
TIP: Press