This site requires JavaScript to be enabled

Banner Pages - Searching/Filtering Tips

42748 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 OptionBasic Filter OperatorDescriptionBasic Filter ExampleExample 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
%enOlsen, 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
RobRob (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
<> SmithSmiths, 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 <> SmithSame as above, plus fields that are blank
IS NULL#IS NULLThis will search for only blank fields#IS NULLOnly blank fields will show
IS NOT NULL#IS NOT NULLThis will search for only fields that are not blank.#IS NOT NULLAny fields that are not blank will show
Less than<This search will return values less than the provided number< 1001, 2 , 3, … 98, 99
Greater Than>This search will return values greater than the provided number> 100101, 102, 103…
Less Than or Equal To<=This search will return values less than or equal to the provided number<= 1001, 2, 3, … 99, 100
Greater Than or Equal To>=This search will return values greater than or equal to the provided number>= 100100, 101, 102…
BETWEEN#BETWEEN x AND yThis search will return results that fall within the number or date range specifiedBETWEEN 01/01/2022 AND 12/31/202507/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