Filter operators

Last updated
Save as PDF

Avalara License Management provides a set of operators for use with report filters. Operators specify how filter criteria relate to each other. The data type of a field determines what operators are available for it. You can apply filters to a report to limit the returned results.

Operator	Data Types	Result	Examples
Equals	Date, Dropdown, Text, Amount	Shows records that match the specified value exactly.	Filter: Active, Equals, Yes The result includes only the active records in a report.
Not equals	Dropdown, Text, Amount	Shows records that don’t have the specified value.	Filter: State, Not equal to, California The result excludes records where the state is selected as California.
Contains	Amount, Text	Shows records that have the search term contained in the actual value.	Filter: First Name, Contains, Ale The result includes records where the first name contains “Ale”, such as Alex, Alessandra, Alexander, and so on.
Does not contain	Amount, Text	Shows records that don’t contain the search term in the field.	Filter: State, does not contain, CA The result excludes records where the state is selected as California, North Carolina, or South Carolina.
Is any of	Amount, Text	Shows records that contain any of the specified search terms.	Filter: State, Is any of, Alaska, California The result includes records where the state is selected as either Alaska or California.
Is none of	Amount, Text	Shows records that don’t contain any of the specified search terms.	Filter: First Name, IS none of, John, Alex The result excludes records that contain the first name as either John or Alex.
Is blank	Date, Dropdown, Text, Amount	Shows records for which there is no value entered in the selected field.	Filter: Email, Is blank The result includes records that don’t contain any email.
Is not blank	Date, Dropdown, Text, Amount	Excludes records without any data.	Filter: Email, Is not blank The result includes records that contain email.
Greater than	Amount	Shows records that contain a value greater than the specified value.	Filter: Amount, Greater than, 100 The result includes records that contain amounts more than $100.
Less than	Amount	Shows records that contain a value less than the specified value.	Filter: Amount, Less than, 100 The result includes records that contain the amount less than $100.
Before	Date	Shows records in which the date is before the specified date.	Filter: Expiration Date, Before, 9/10/21 The result includes records that expire before 9/10/21.
After	Date	Shows records in which the date is after the entered date.	Filter: Expiration Date, After, 9/10/21 The result includes records that expire after 9/10/21.
Between	Date	Shows records in which the date is within the specified range.	Filter: Expiration Date, Between, 1/10/21, 25/10/21 The result includes only records that expire between the 25 days range.
In current year	Date	Shows records where the date is within the current year.	Filter: Expiration Date, In current year The result includes records that expire in the current year.
In current month	Date	Shows records where the date is within the current month.	Filter: Expiration Date, In current month The result includes records that expire in the current month.
Year equals	Date	Shows records where the year is the same as the specified year.	Filter: Expiration Date, Year equals, 2020 The result includes records that expire in the year 2020.
Month equals	Date	Shows records where the month is the same as the specified month.	Filter: Expiration Date, Month equals, January The result includes records that expire in January, regardless of the year of the expiration date.
Past X days	Date	Shows records where the date is between today and the specified number of days in the past.	Filter: Expiration Date, Past X days, 20 The result includes records that expire within the last 20 days.
Next X days	Date	Shows records where the date is between today and the next number of specified days.	Filter: Expiration Date, Next X days, 21 The result includes records that expire within the next 20 days.