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
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
, Mike Hoffman, , Alex Galchenyuk, Bobby Ryan, , , Isac Lundestrom, Zack Kassian, Zach Aston-Reese, Michael Mersch
Custom OT Lines Defensemen
, Jarred Tinordi, Ben Harpur, Brett Lernout, Joona Koppanen
Filter Tips
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
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
Prospect
Team Name
Draft Year
Overall Pick
Information
Lien
Aaron Rome
Canadiens
Albert Yarullin
Canadiens
Alexei Bereglazov
Canadiens
Alexei Emelin
Canadiens
Andrej Meszaros
Canadiens
Ben Jones
Canadiens
Benoit Brunet
Canadiens
Benoit-Olivier Groulx
Canadiens
20
33
Branden Troock
Canadiens
Brent Moran
Canadiens
Brett Murray
Canadiens
Cam York
Canadiens
21
13
Casey Fitzgerald
Canadiens
Colten Ellis
Canadiens
21
62
Daniel Carcillo
Canadiens
Daniel Catenacci
Canadiens
Daniel Zaar
Canadiens
David Broll
Canadiens
Drew Miller
Canadiens
Dylan Cozens
Canadiens
21
4
Eric Gelinas
Canadiens
Evan Barratt
Canadiens
Frankie Simonelli
Canadiens
Garnet Exelby
Canadiens
German Rubstov
Canadiens
Guillaume Latendresse
Canadiens
Hugo Danielsson
Canadiens
Jack Ahcan
Canadiens
James Sheppard
Canadiens
Jan Jenik
Canadiens
20
68
Jan Kern
Canadiens
Jani Lajunen
Canadiens
Jarome Iginla
Canadiens
Jeremy Morin
Canadiens
Jesse Koskenkorva
Canadiens
Jesse Winchester
Canadiens
John Erskine
Canadiens
John Marino
Canadiens
John Persson
Canadiens
Joni Ikonen
Canadiens
Josh Nodler
Canadiens
21
222
Josh William
Canadiens
21
98
Justin Sefton
Canadiens
Kari Lehtonen
Canadiens
Kent Patterson
Canadiens
Luc Snuggerud
Canadiens
Mario Ferraro
Canadiens
Mark Olver
Canadiens
Massimo Rizzo
Canadiens
21
242
Matej Stransky
Canadiens
Matt Greene
Canadiens
Matt MacKenzie
Canadiens
Matt Marquardt
Canadiens
Michael Downing
Canadiens
Mike Halmo
Canadiens
Mitch Mattson
Canadiens
Nick Ellis
Canadiens
Nick Larson
Canadiens
Noah Dobson
Canadiens
20
7
Pierre Dagenais
Canadiens
Radim Vrbata
Canadiens
Richard Nejezchleb
Canadiens
Riley Tufte
Canadiens
Rob Flick
Canadiens
Rocco Carzo
Canadiens
Roman Cervenka
Canadiens
Ryan Button
Canadiens
Ryan Shea
Canadiens
Ryan Watson
Canadiens
Sasha Mutala
Canadiens
21
122
Scott Valentine
Canadiens
Shayne Taker
Canadiens
Tyrel Seaman
Canadiens
Zachary Lauzon
Canadiens
Draft Picks
Year
R1
R2
R3
R4
R5
R6
R7
R8
22
MTL
MTL
MTL
MTL
MTL
MTL
23
MTL
MTL
MTL
MTL
MTL
MTL
MTL
24
MTL
MTL
MTL
MTL
MTL
MTL
MTL
MTL
25
MTL
MTL
MTL
MTL
MTL
MTL
MTL
MTL
26
MTL
MTL
MTL
MTL
MTL
MTL
MTL
MTL
[2019-12-04 18:53:55] - TRADE : From Devils to Canadiens : Mike Hoffman (71). [2019-12-04 18:53:55] - TRADE : From Canadiens to Devils : Conor Garland (62). [2019-10-02 00:26:45] - TRADE : From Flames to Canadiens : Alexander Steen, Zack Smith. [2019-10-02 00:26:45] - TRADE : From Canadiens to Flames : Y:23-RND:5-MTL, Y:22-RND:6-PHI. [2019-08-24 12:01:39] - Canadiens hired Joel Quenneville for 3 000 000 $ for 3 year(s). [2019-07-30 22:46:58] - Jayden Halbgewachs resigned with Canadiens for 840 000 $ for 3 year(s). [2019-07-30 22:46:37] - Ben Harpur resigned with Canadiens for 931 000 $ for 3 year(s).