Home > Features > Data > Advanced Filter Criteria

Advanced Filter Criteria

Advanced Filter  functions identically to Excel's Advanced Filter feature with the copy to another location option (the report is the other location).  It does NOT filter the data set in place.  Records that do not meet the filter criteria will not be in the report. 

This following data set will be used to show how the criteria changes the reports output.

ID First Name Last Name Order
1 Jane Doe Milk
2 John Doe Eggs
3 Eleni Smith Milk
1 Jane Doe Butter

EXAMPLE

Filter Description Criteria Results
Return all records where
First Name = Jane
ID First Name Last Name Order

Jane

ID First Name Last Name Order
1 Jane Doe Milk
1 Jane Doe Butter
Return all records where
the Order field is blank
ID First Name Last Name Order



="="

Note: only the equal sign,  will be visible

ID First Name Last Name Order
3 Eleni Smith
Return all records where
the Order field is not blank
ID First Name Last Name Order



="<>"

Note: only the less than/greater than signs, <>  will be visible

ID First Name Last Name Order
1 Jane Doe Milk
2 John Doe Eggs
1 Jane Doe Butter
Return all records where
First Name begins with the letter J
OR the Order field has the letter e in it
ID First Name Last Name Order

j*




*e*
ID First Name Last Name Order
1 Jane Doe Milk
2 John Doe Eggs
1 Jane Doe Butter
Return all records where
First Name begins with the letter J
AND the Order field has the letter e in it
ID First Name Last Name Order

j*
*e*
ID First Name Last Name Order
2 John Doe Eggs
1 Jane Doe Butter










































































See also

Duplicates
Search and Replace
Denormalize