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
|