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
Zemgus Girgensons, Scott Gomez, Jake Guentzel, Kyle Brodziak, Andrew Shaw
Goalie
#1 : Keith Kinkaid, #2 : Connor Hellebuyck
Custom OT Lines Forwards
, , , , , , , , , ,
Custom OT Lines Defensemen
, , , ,
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
Alexander Nylander
San Jose
2016
7
Austin Wagner
San Jose
2015
100
Brennan Menell
San Jose
2015
189
Cam Dineen
San Jose
2016
81
Cooper Marody
San Jose
2015
145
Kale Clague
San Jose
2016
66
Libor Hajek
San Jose
2016
42
Matthew Phillips
San Jose
2016
173
Noah Gregor
San Jose
2016
96
Otto Somppi
San Jose
2016
200
Rasmus Asplund
San Jose
2016
30
Reid Duke
San Jose
2015
184
Riley Stillman
San Jose
2016
156
Rourke Chartier
San Jose
2015
54
Samuel Montembeault
San Jose
2015
82
Thomas Chabot
San Jose
2015
22
Tyler Wall
San Jose
2016
181
Draft Picks
Year
R1
R2
R3
R4
R5
R6
R7
2017
San
San Chi
San Was
San
San Atl
San
Stl
2018
San
San
San
San
San Stl
San Atl
San
2019
San
San
San
San
San
San
San
2020
San
San
San
San
San
San
San
2021
San
San
San
San
San
San
San
[2016-09-11 15:34:27] - Casey Nelson was added to San Jose. [2016-09-16 21:13:17] - Brad Richards was added to San Jose. [2016-09-16 21:13:21] - Joel Hanley was added to San Jose. [2016-09-16 21:13:29] - Tyler Randell was added to San Jose. [2016-10-08 09:48:59] - Scott Gomez was added to San Jose. [2016-10-08 09:48:59] - TRADE : From Detroit to San Jose : Scott Gomez (61), 400 000 $ (Money). [2016-10-08 09:48:59] - TRADE : From San Jose to Detroit : 1 $ (Money). [2017-01-11 20:00:20] - New Record for Team's Most Shots Blocked (20) in 1 Game for San Jose! [2017-02-04 10:35:17] - TRADE : From Montreal to San Jose : Y:2018-RND:5-Stl. [2017-02-04 10:35:17] - TRADE : From San Jose to Montreal : John-Michael Liles (65). [2017-02-18 20:00:23] - New Record for Team's Most Hits (33) in 1 Game for San Jose! [2017-03-02 00:05:49] - TRADE : From Montreal to San Jose : Cam Dineen (P). [2017-03-02 00:05:49] - TRADE : From San Jose to Montreal : Edward Purcell (66).