Frequently Asked Questions
The Ad Hoc Query is a powerful search tool that provides flexible query options for a multitude of search criteria.
Ad Hoc Query Reports
The Ad Hoc Query feature allows you to search for a particular data from Group A Incidents or Group B Arrests. It also allows you to:
- Save the actual query (Agency use only)
- Download the search results as a CSV file
- Download the search results as an Excel file
Following is a short description of the criteria fields required to create a query:
Field Name |
Description |
Search For |
Select the type of record to search from the dropdown |
Section |
The segment type that you want to search |
Element |
A field within the segment that you have chosen |
Operator |
Specifies a relationship between the element and its value |
Value |
Defines the element that you are searching |
- From the ‘Search For’ drop-down menu, select the item that you want to search for from the following options:
- Group A Incident
- Group B Arrest
- From the ‘Section’ drop-down menu, select a segment that you want to search. (Admin, Offense, Property, Victim, Offender, Arrestee)
- From the ‘Element’ drop-down menu, select the element type that you want to use in the search. (ORI Number/Agency Name, Incident Number, Cargo Theft, Incident Date, Report Date Indicator, Incident Hour, Cleared Exceptionally, Clearance Date)
- From the ‘Operator’ drop-down menu, select the corresponding operator (equal and all except)
- In the ‘Value’ field, enter the corresponding value (ORI to perform the search on, or ALL)
Add Multiple Criterion:
Multiple criteria can be added or removed using the ad hoc query tool. As the user keeps adding or deleting criteria to the query, the query results are also modified accordingly. To add another row of criteria, click the blue + (plus) icon highlighted in red in the below screenshot:
- Click the green ‘Search’ button
- Search results are displayed
- From the Search Results data grid, click any record to open the individual report
A Sample query created on the Ad Hoc query tool is shown below:
Save Query (Agency Use Only)
All queries, simple or complex, can be saved and used in the future by just clicking on the ‘Save Query’ button.
Give the saved query a name in the ‘Query Name’ box. Click the ‘Shared Type’ toggle switch to either ‘Private’ or ‘Public’. If set to ‘Public’ an Agency box appears and the user can select an agency or ALL from the dropdown list. If set to ‘Private,’ only the user can view the query. Then click the blue ‘Save’ button or gray ‘Cancel’ button. The query gets saved under the second tab on the page which is the ‘My Saved Queries’ tab.
An example of the ‘My Saved Queries’ page is shown below, which includes the Query Name, Query Condition, and Create Date. Each query can be viewed, edited or deleted by clicking the “View” eye icon, the “Edit” paper and pen icon or the “Delete” garbage can icon respectively: