Ad Hoc Queries: Difference between revisions
No edit summary |
No edit summary |
||
| Line 29: | Line 29: | ||
:Repeat for any additional queries that you wish to use. | :Repeat for any additional queries that you wish to use. | ||
====Boating Citations and Warnings==== | =====Boating Citations and Warnings===== | ||
====CFS Location by Date==== | =====CFS Location by Date===== | ||
====Crashes by Location==== | =====Crashes by Location===== | ||
====Crashes With Approving Supervisor==== | =====Crashes With Approving Supervisor===== | ||
====Crashes With Bicyclists and Pedestrians==== | =====Crashes With Bicyclists and Pedestrians===== | ||
====Crashes With Motorcycles==== | =====Crashes With Motorcycles===== | ||
====Crashes With Citations Issued==== | =====Crashes With Citations Issued===== | ||
====Crashes With Motorcycles==== | =====Crashes With Motorcycles===== | ||
====Crashes With Suspected Alcohol or Drug Use==== | =====Crashes With Suspected Alcohol or Drug Use===== | ||
====FIBRS Crime Stats==== | =====FIBRS Crime Stats===== | ||
====FIBRS Incident Count - Location & Zone==== | =====FIBRS Incident Count - Location & Zone===== | ||
====FIR With Race and Gender - ''Coming in a future release''==== | =====FIR With Race and Gender - ''Coming in a future release''===== | ||
====Parking Citations and Warnings==== | =====Parking Citations and Warnings===== | ||
====Speeding Citations With Posted Speed & Violator Speed==== | =====Speeding Citations With Posted Speed & Violator Speed===== | ||
====Traffic Warning Search with DOB==== | =====Traffic Warning Search with DOB===== | ||
====Trespass Warnings Name and Address Search==== | =====Trespass Warnings Name and Address Search===== | ||
====UAA Search With Age==== | =====UAA Search With Age===== | ||
====UTC by Location==== | =====UTC by Location===== | ||
====UTC Crashes & Aggressive Driving==== | =====UTC Crashes & Aggressive Driving===== | ||
====UTC Search with DOB==== | =====UTC Search with DOB===== | ||
====UTC Seatbelt Violations Written for Crash Reports==== | =====UTC Seatbelt Violations Written for Crash Reports===== | ||
====UTC Speeding in School Zone==== | =====UTC Speeding in School Zone===== | ||
====UTC Top Violations==== | =====UTC Top Violations===== | ||
====UTC's Written for Crashes==== | =====UTC's Written for Crashes===== | ||
====Voided & Deleted Citations With Officer Name & Violator Name==== | =====Voided & Deleted Citations With Officer Name & Violator Name===== | ||
====Warnings With Race, Gender, and Officer Name==== | =====Warnings With Race, Gender, and Officer Name===== | ||
====Warnings by Location==== | =====Warnings by Location===== | ||
Revision as of 13:56, 8 May 2024
Overview
The AdHoc Queries feature is located on the Advanced Tab in the forms manager. All users have access to it.
An ad hoc query will pull a list of forms based on criteria specified by the query creator. Nearly every field on a form may be queried.
The results come up in a report format that may be printed or may be exported to Excel, CSV, or PDF.
If you want your results to show in the Forms Manager instead of the report format, the Advanced Search should be used.
Creating & Sharing Ad Hoc Queries
For more information on creating ad hoc queries, see the How to Create an Ad Hoc Query page.
Once created, ad hoc queries may be shared between users. 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.
Available 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.