Queries Status

Queries is a tab on the Status Dashboard. The tab displays the current status of requested query actions. The Queries tab displays the Criteria Set Status List, which allows you to view/action the queries you have submitted.

Filter the Criteria Set Status List

You can limit the number of criteria sets that display on the list by typing or selecting criteria in the filter fields and then clicking the button. To clear your criteria click the button. Click the button to restore the filter to its default settings.

If you choose to use more than one filter criteria the list will include only those that match all criteria. For example, if you choose type carrier 01 in the Carrier field and tariff TAFP in the Tariff field, the list will return criteria sets that contain a query for both carrier 01 and tariff TAFP.

Filter Fields

Field Name	Field Description
View	Options on this field include My Criteria Sets and All Criteria Sets. The first option will narrow the list to only those criteria sets that you submitted. The second option will narrow the list to show criteria sets that were submitted by all users at your organization.
Carrier	Type a carrier code in this field to limit results to only those criteria sets that contain a query for the indicated carrier.
Tariff	Type a tariff code in this field to limit results to only those criteria sets that contain a query for the indicated tariff.
Name	Type the name of a criteria set to display on that set on the list.
Status	Choose a status from the Status drop-down menu to limit results to only those that hold the indicated processing status. Options include: All, Cancelled, Cancel Requested, Executing, Failed (including Exceed Max), Queued, Queued or Executing, and Successful. To display Exceed Max, use options All or Failed.
Scope	Select the scope of the fares from the Scope drop-down menu to limit results to only those that are included in the indicated scope. Options include: International, US/CA (US and Canada), and Add-on.
User ID	Type a user identification code in this field to limit results to only those submitted by the indicated user. Partial entries are accepted. For example, if you type X01 in the User ID field, all criteria sets submitted by users whose user identification codes begin with X01 will be listed. You may also use a dash as a wildcard value. For example, if you type -AWN in the User ID field, all criteria sets submitted by users within your organization whose user identification codes end with AWN will be listed.
Submit Date Min/Max	Type dates in these fields using the DDMMYY format or click the button to select dates from a calendar. Both fields must be used when this filter option is exercised. The minimum date must be earlier than or equal to the maximum date. The criteria sets returned will be limited to only those that were submitted within the indicated date range.

How to Read the Status List

Field Name	Field Description
Name	This field displays the job name, which is automatically assigned by the Fares program.
Status	The status of the job may be Queued (awaiting execution), Executing, Successful (complete), Cancel Requested, Cancelled (cancelled by a user), and Failed.
Submit Type (Results)	The Submit Type (Results) field indicates the type of action that was requested to be performed by the criteria set/query. Options include: Submit Inquiry, Submit Preview, and Submit to Batch.
Source	The Source field indicates the data source that was selected when the criteria set/query was created. Options include Master (the database) and Transaction (a batch).
Scope	The Scope field indicates the type of fare that was indicated when the criteria set/query was created. Options include International, US/CA,and Add-on.
Queries	The Queries field indicates the number of queries that were included in the submitted criteria set/query. For example, it’s possible to have a query requesting all fares from LON to NYC and, in the same criteria set, another query requesting all fares from LON to BOS that hold footnote B. In this example, the number of queries that would be indicated in the Queries field is two. For more information, see Create Criteria Sets and Queries. This number is not the same as the numbers in parenthesis next to the Queries link on the status bar or the numbers in parenthesis next to the title of the Queries tab. The numbers in parenthesis indicate the total number of criteria sets that are present on the Criteria Set Status List.
User ID	The User ID field displays the user identification of the person who submitted the criteria set/query.
Submitted	The Submitted field displays the date and time that the criteria set/query was submitted. US Eastern times are shown.
Completed	The Completed field displays the date and time that the criteria set/query completed processing. US Eastern times are shown.

Action Buttons

Refresh

Click the button to reload information on the Criteria Set Status List.

View Status Details

Select a row on the Criteria Set Status List and then click the button. The Criteria Set – Status Detail dialog box will display. The dialog box is divided into two tabs: Criteria Set Summary and Status Details.

Criteria Set Summary Tab

This dialog box displays a summarized view of the data that was specified in the inclusions, exclusions, changes, and matches group boxes for each query in the criteria set. If you wish to make changes, you can access the criteria set by clicking the button.

Status Details Tab

The Status Details tab is divided into two group boxes: Status and Found Fares.

Status Group Box

This group box displays a history of the processes performed during the requested action on the criteria set. For example, the times that the criteria set’s status changed from queued to executing and then to successful (complete) will be shown along with the user identification of the person who submitted the request.

Fares Found Group Box

This group box displays a summary of the number of fares found, changed, and matched for each query in the criteria set.

If the Criteria set has a status of Executing when the View Status Detail button is clicked, there will be a third section on the Status Details tab called the Criteria Set Progress Point. The Criteria Set Progress Point will show the carrier, tariff, origin location, and destination location point the system is currently processing.

View Results

If the action requested for the criteria set was Submit Inquiry or Submit Preview, select the criteria set’s row on the Criteria Set Status List and then click the button. The Selection Results and Changed Fares tabs will display. For information about these tabs, see Selection Results and Changed Fares.

Edit Criteria Set

You can return to a criteria set, make changes, and then resubmit it. To access a criteria set, select its row on the Criteria Set Status List and then click the button.

Cancel

If the requested action on a criteria set has not yet completed processing, you can cancel the action. Select its row on the Criteria Set Status List and then click the button.

View Batch

If the request action for the criteria set was Submit to Batch, you can access the batch in View mode from this dialog box. Select its row on the Criteria Set Status List and then click the button.

If more than one batch was created, only the first batch will display.

Edit Batch

If the request action for the criteria set was Submit to Batch, you can access the batch in Edit mode from this dialog box. Select its row on the Criteria Set Status List and then click the button.

If more than one batch was created, only the first batch will display.
If the batch is already in Edit mode with another user, an Alert message will display.

Submit Inquiry

When the status of a criteria set is other than Exceeds Max or Cancel Requested, you can now select the row on the Criteria Set Status List and then click the button to resubmit the same criteria as previously coded.

Submit Preview

Submit to Batch

When the status of a criteria set is other than Exceeds Max or Cancel Requested, you can now select the row on the Criteria Set Status List and then click the button to resubmit the criteria set as previously coded.

The Submit Inquiry, Submit Preview, and Submit to Batch functionality will only take the action of the information as coded in the selected criteria set