Ligue Calendrier École

Astuces sur les Filtres (Anglais seulement)

Priority	Type	Description
1	| or  OR	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