Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
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.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
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.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar
2
&& or AND
Logical "and". Filter the column for content that matches text from either side of the operator.
3
/\d/
Add any regex to the query to use in the query ("mig" flags can be included /\w/mig)
4
< <= >= >
Find alphabetical or numerical values less than or greater than or equal to the filtered query
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.
6
" or =
To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query
7
- or to
Find a range of values. Make sure there is a space before and after the dash (or the word "to")
8
?
Wildcard for a single, non-space character.
8
*
Wildcard for zero or more non-space characters.
9
~
Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query
10
text
Any text entered in the filter will match text found within the column
Calgary Flames
Minnesota Wild
Nashville Predators
Ottawa Senators
Philadelphia Flyers
Vancouver Canucks
Washington Capitals
Buffalo Sabres
Carolina Hurricanes
Edmonton Oilers
Montreal Canadiens
St. Louis Blues
Winnipeg Jets