Finale Knowledge Base

Using Operator Functions in Filter Searches

Finale has the ability to use "Include" and "Exclude" operators as well as the ability to filter including or excluding blank values for the field filters on list views, reports, and automation rules.


Operator Selection

Source filter with a red arrow pointing at it and its operator menu open, with Include matching sales and Exclude blank values selected

The option labels combine the action with the current list. Include matching and Exclude matching stay the same; the last word reflects the list you are filtering, such as sales, purchases or products.

Any field that has the turn down arrow supports this functionality. Using the turn down arrow, select which operator you want to use and then choose your value (or enter your value) in the filter.


Operator Details

  • Include Matching: This option is the traditional behavior. All matches to the filter value will display. This is an OR filter, so if you choose several options, it will display ANY result that matches one or more of the filter values.

  • Excludes Matching: This option is the opposite of Include. Any row that contains any of the values in the filter will be excluded from the result.

  • Include Blank Values: This option will include rows that have no value. To use this, a value must be entered into the filter. It does not work to only display blanks if this option is selected and no value is entered into the filter.

  • Exclude Blank Values: This option will exclude rows that have no value. To use this, a value must be entered into the filter. It does not work to exclude blanks if this option is selected and no value is entered into the filter.


Examples

Tags

  • Scenario: Filter to orders that have the tag "TikTok"

  • Configuration: Filter set to "Include Matching" and "Exclude Blank Values". Choose tag and search.

This will return all orders that have the tag TikTok only.


Shipping Speed

  • Scenario: Processing orders for shipping that are expedited shipping. Filter out orders that are standard shipping.

  • Configuration: Filter set to "Exclude Matching" and select the ground option. "Exclude Blank Values".

This will return any order that does not have a ground option specified. Ideal if there are several expedited shipping options (next day, 2nd day, expedited) but only one ground option.


Completed Order Auditing

  • Scenario: Find completed orders that are not fully shipped

  • Configuration: Order Status filter set to "Completed". Shipment Status Summary filter set to "Exclude" "Fully Shipped"

This will return any order that is marked completed but has not been fully shipped.