The input fields at the top of each column allow you to search for specific products within the search results.

Any text entered in the filter will match text found within the column. For example abc (finds "abc", "abcd", "abcde", etc); Aaron: (finds "Aaron" and "Philip Aaron Wong")

Below are some of the more powerful features of the filter.

Priority	Type (1)	Description	Examples
1	| or  OR	Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar (2).	box|bat (matches a column cell with either "box" or "bat"); Alex|Peter: (Find text that contains either "Alex" or "Peter"); <20 or >40:
2	&&  or  AND	Logical "and". Filter the column for content that matches text from either side of the operator.	box && bat (matches a column cell that contains both "box" and "bat"), Br && c: (Find text that contains both "br" and "c"), >20 && <40: or a and !o: (When "filter-match" is set, find content with the letter "a", but not the letter "o")
3	/\d/	Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)	/b[aeiou]g/i (finds "bag", "beg", "BIG", "Bug", etc); /r$/: (matches text that ends with an "r")
4	< <= >= >	Find alphabetical or numerical values less than or greater than or equal to the filtered query (1).	>= 10: (find values greater than or equal to 10)
5	! or !=	Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter (v2.17.1).	!fe (hide rows with "female" in that column, but shows rows with "male"); !a: (find text that doesn't contain an "a"); !"Bruce": (find content that does not exactly match "Bruce")
6	" or =	To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query	abc" or abc= (exactly match "abc"); John": or John=: (exactly match "John")
7	-  or  to	Find a range of values. Make sure there is a space before and after the dash (or the word "to") (3).	10 - 30: or 10 to 30: (match values between 10 and 30)
8	?	Wildcard for a single, non-space character.	J?n (finds "Jan" and "Jun", but not "Joan");a?s: (finds "Dumass" and "Evans", but not "McMasters")
8	*	Wildcard for zero or more non-space characters.	B*k (matches "Black" and "Book");a*s: (matches "Dumass", "Evans" and "McMasters")
9	~	Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query (v2.13.3)	~bee: (matches "Bruce Lee" and "Brenda Dexter"), or ~piano: (matches "Philip Aaron Wong")