Record retrieval

Service Manager allows you to search for and retrieve database records based on particular user-provided search criteria (query). Searching is case-sensitive by default, unless your database has been set up for case-insensitive searching. For information on how to improve query speed, see the Help topic Tuning: Improving query speed.

There are three methods of querying records from a Service Manager database:

  • Simple queries are defined using the record list method.
  • More complex queries are defined using the query window method.
  • Other queries can be performed using IR Expert information retrieval.

Related topics

The Database Manager utility
Relational operators
Logical operators
Wildcard characters
Record list
Queries
Retrieving records by using the record list method
Retrieving records using the Query window method

Perform IR Expert queries

Service Manager Programming
Tuning: Improving query speed