Ad Hoc Queries

Overview

An ad hoc query will pull a list of forms based on criteria specified by the query creator.   The results come up in a format that may be exported to Excel, CSV, or PDF or printed.   Nearly every field on a form may be queried.

For more information on creating ad hoc queries, see the How to Create an Ad Hoc Query page.

If you have created an ad hoc query and want to share it with others at your agency, see the How to Share Queries page.

Pre-Built Ad Hoc Queries

There are several pre-built ad hoc queries available within TraCS.

All TraCS users may access them by going to the Advanced tab and then choosing AdHoc Queries.

Right click in the white space and click Import.

Select the ad hoc query that you wish to import and then press Open.

The query will open to the search criteria screen.

Press Finish and the query will appear on your list.

Repeat for any additional queries that you wish to use.

If you would like to learn how to create your own ad hoc queries, see the How to Create an Ad Hoc Query page.