Querying is a way to locate one or more records that meet your criteria. The subset of records found by a query can be viewed on-screen, exported to a file, or used as input for a report. A query searches the database for a specific subset of data based on one or more conditions or criteria. For example, you may need to find all open service requests with a high priority. This query is performed in the Service screen with the query criteria of Status = Open and Priority = High.

When you create a query, you can save and reuse the criteria.

Topics in This Section

About Predefined Queries

Creating, Executing, and Saving Queries

Refining Queries

Deleting Queries

Using the Query Assistant

Using Default Queries

Querying a Telephone Number

Simple Query Operators

Compound Query Operators

Query Tips

Related Topics

Querying for Records in a Selection Dialog Box

Setting Up Default Queries

Displaying Record Count