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?