Creating an Advanced Query for Merchant Category Codes

You can perform complex searches for Merchant Category Code information using advanced search options.

After you run an Advanced Query, you can save it for future use. Saved queries are available from the Query list on the Merchant Category Code List screen. You can also set an Advanced Query as the default query. The default query is run every time you display the Merchant Category Code List screen. For more information, see Managing Advanced Queries.

To create an Advanced Query for Merchant Category Codes:

  1. Select Administration > Merchant Category Codes.

  2. Click Advanced Query.

  3. Complete the Criteria fields.

    Field

    Select the field by which you want to search.

    Operation

    Select the operation you want to use to measure the field value. The available operations will vary based on the field you select. Possible values are: Begins With, Contains, Is Between, Is Equal To, and Is Not Equal To.

    Value

    Specify the field value. Depending on the type of field, you may be required to select a value from a drop-down list, enter a value in the text box, or select a check box.

    To add more criteria, click Add and complete the added fields. Use the Operator list to indicate whether an MCC must satisfy all the criteria (select All) or only one of the criteria (select Or) to be included in the query results. Repeat this step as often as necessary to specify all the criteria for your search.

    To remove search criteria, click the corresponding Delete button.

  4. To sort the search results, click the Add and complete the Order By fields.

    Field

    Select the field by which you want the search results to be sorted.

    Order Sequence

    Select the display order, either Ascending or Descending.

    To sort by additional fields, click Add again and complete the added fields. Repeat this step as often as necessary to specify all the fields for the sort.

    To remove a field from the sort order, click the corresponding Delete button.

  5. To run your query, click Process. The query results display on the Merchant Category Code List screen.