Skip to main content
Avalara Help Center

Filter Operators

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.

  • Was this article helpful?