Banner Pages Search and Filter - Tips and Tricks
Using the advanced filter handles the operators for you. You simply choose your filter option and enter the appropriate data to filter. The table below describes a few of the advanced filter options.
If you prefer the layout of the basic filter, you can also use certain operators in the basic filter view which will change the comparison from the default of “Equals”. For example, the % wildcard can be used to represent zero or more additional characters - changing the comparison from “Equals” to “Contains”, “Starts With”, or “Ends With” depending on where you place the % symbol(s).
The table below shows the advanced filter option, the equivalent basic filter operator, and provides a description and gives examples. The table is not a comprehensive list.
Filter Options and Equivalent Operators
Advanced Filter Option | Basic Filter Operator | Description | Basic Filter Example | Example Results |
Contains | % | This searches for the characters you provide anywhere in a field % is placed both at the beginning and end |
%an% | Megan, andrew, Casandra |
Starts With | % | This searches for the characters you provide at the beginning of the field % is placed only at the end |
An% | Angela, Anthony |
Ends With | % | This searches for the characters you provide at the end of the field % is placed only at the beginning |
%en | Olsen, Jensen, Steven |
Equals | This searches for the exact match of the characters you provided. If data has any additional characters, they will not be returned NOTE: Default behavior for Basic Filter, No Operator needed |
Rob | Rob (but not Robert) | |
Not Equal | <> | This searches for anything that doesn’t match the exact characters you provided but does not return results that are blank |
<> Smith | Smiths, Jones, Lee (ANYTHING but Smith) |
Not Equal or IS NULL | #IS NULL #OR <> | This is the same search as the previous search but it will return records that are blank | #IS NULL #OR <> Smith | Same as above, plus fields that are blank |
IS NULL | #IS NULL | This will search for only blank fields | #IS NULL | Only blank fields will show |
IS NOT NULL | #IS NOT NULL | This will search for only fields that are not blank. | #IS NOT NULL | Any fields that are not blank will show |
Less than | < | This search will return values less than the provided number | < 100 | 1, 2 , 3, … 98, 99 |
Greater Than | > | This search will return values greater than the provided number | > 100 | 101, 102, 103… |
Less Than or Equal To | <= | This search will return values less than or equal to the provided number | <= 100 | 1, 2, 3, … 99, 100 |
Greater Than or Equal To | >= | This search will return values greater than or equal to the provided number | >= 100 | 100, 101, 102… |
BETWEEN | #BETWEEN x AND y | This search will return results that fall within the number or date range specified | BETWEEN 01/01/2022 AND 12/31/2025 | 07/21/2022, 10/08/2024… |
Additional Operators
You can learn additional operators by using the advanced filter dropdowns, switching back to the basic filter, and observing the operators placed in the basic filter for that field. Refer to the image below.
Image: Additional operators can be viewed when you switch from the advanced filter back to the basic filter view