Create Criteria Sets and Queries

By default the International radio button is selected for the Scope and the Master radio button is selected for the Source when you click the Query tab (Criteria Set screen). If a different scope and source are needed then make another selection from the Scope (International, US/CA, or Add-on) and Source (Master or Transaction) fields. Upon selecting the desired scope and source, click the button to display the Criteria Set: NEW CRITERIA SET screen. This is a blank query, which requires you to enter data in required fields (identified with a red asterisk *) in order to create the new criteria set.

The NEW CRITERIA SET screen consists of four group boxes: Inclusions, Exclusions, Changes, and Matches.

Use the fields in the Inclusions group box to locate selection results based on entered criteria. For example, you can enter information to include fares filed between the United States and Europe.
Use the fields in the Exclusions group box to locate and ignore selection results based on entered criteria. For example, you can enter information to include fares filed between the U.S. and Europe, except for fares filed to/from WAS.
Use the fields in the Changes group box to add, modify, cancel and restore fares identified in the selection criteria. For example, you can enter information to include fares filed between the U.S. and Europe, except for fares to/from WAS and increase the fares by 10%.
Use the fields in the Matches group box to modify fares based on the amount of another carrier’s fares, or your own existing fares, as identified in the selection criteria. For example, you can enter information to include fares filed between the U.S. and Europe, except for fares filed to/from WAS, and increase the fares by 10% if they exist at lower fare amounts compared to other airlines.

The Tariff and Carrier fields, located in the Inclusions group box, are required for each criteria set. Not entering data in these two fields will result in an error message displayed in a red box at the top of the screen. If additional queries need to be coded, then you can click the or button. The button will open up a new blank query within your Criteria Set. The button will create a new query within the criteria set, but will retain the information of the query that you copied from.

If multiple queries are created and one of the queries is not needed, then click the button to remove the query. You can also clear all the fields within a group box by clicking the button.

Once all of the necessary queries have been created you can either save and/or submit the criteria set. For more information on how to save or copy a criteria set please see Saving and Copying a Criteria Set.

When using tariff values of “Any”, “Any Public”, and “Any Private”, the query set must only contain a single query number in a criteria set.