This site requires JavaScript to be enabled

Banner Pages - Searching/Filtering Tips

101447 views

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