Find Query
- Michelle Cabaya
- Amy Mangueira
This page is for the Operations App. For the Classic Operations App please see Find Query (Classic Operations App).
- 1 Query
- 1.1 Use Saved Query
- 1.2 Query
- 1.2.1 Basic Find
- 1.2.2 Advanced Find
- 1.3 Options
- 1.4 Save Query
- 2 Query Result Options
- 3 Query Management
- 4 Update Finds/Reports
- 4.1 Finds
- 4.2 Report Formats
Find allows you to create basic and advanced queries to help find information in the Operations App. These queries can be saved along with the ability to download advanced queries that have been created by CXT Software.
The Find permissions are required to use Find. See Users.
In the left navigation, go to Find Query.
Query
The Query tab allows you to create, save, or execute saved queries.
Use Saved Query
Use Find Search or Favorites to search or select a favorite query to execute.
Field Name | Description |
|---|---|
Find Search | Click this field to search and select from a drop-down or begin typing to search for a saved find. |
Favorites | Click this field to search and select from a drop-down or begin typing to search for a favorite find. |
Query
Basic Find
Select Basic Find to create basic finds. This is the default option.
Use the following fields to help create a query.
If the query criteria does not include date parameters, a default date range of +/- 30 days is applied in order to avoid performance issues from extremely large result sets. On-Demand orders will be based on Date Ready and route stops will be based on Post Date."
Field Name | Description |
|---|---|
Find | Select what you would like to search for. The Basic Find allows you to pick from the following:
|
Where | Select the field name of the data you would like to search for. The list of fields will vary depending on what you have selected for Find. |
Operator | Select an operator for your search criteria. The Basic Find allows you to pick from the following:
The following are available operators if Where are number or date values.
|
Value | Enter or select the value for the search criteria you are looking for. Depending on what you are searching for, this field can accept a number, date, or text. |
And/Or | If you need to add additional search criteria, you can select AND or OR. ExampleYou want to only show the orders placed yesterday for a customer.
|
| Click the delete icon on the right side of the search screen for any lines of criteria you would like to remove. |
| Click to add additional search criteria. |
Advanced Find
Select Advanced Find to create advanced finds.
Enter the SQL statement you would like to use for your Advanced Find in the SQL Text field. You can use the filters (SQL Syntax, Tables, Table Columns) to help create the SQL statement by filtering the SQL syntax, database table, and column (this is populated based on the database table selected).
The Record Type to Display field can be used if the result record displayed is not what you expect. Updating this field will override the default result record type to display when double-clicking on a record to open it. This setting has to be changed before executing the find to apply to the results.
Options
You can select how the Find results will be displayed.
Field Name | Description |
|---|---|
Include Invoiced Records | When checked, invoiced records will be included in the results. |
Max Records | Required. The maximum number of records returned in the results. |
Report Formats | Selected report format for the results. |
Save Query
You can save a new query or update an existing one by clicking on the save icon in the bottom right.
The Save icon is enabled when the Filter Name is entered.
Field Name | Description |
|---|---|
Filter Name | Name of the query. |
Group Query | The group that the query is/will be assigned to. |
Description | Description of the query. |
Save As Favorite | If checked, the query will be saved as a Favorite. |
Query Result Options
After you have run a successful query, you will have a few additional options in the icon bar above the results.