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
Connor McDavid, Frank Vatrano, Barrett Hayton, Tim Stutzle, Phillip Danault
Goalie
#1 : Joonas Korpisalo, #2 : Calvin Pickard
Custom OT Lines Forwards
Connor McDavid, Barrett Hayton, Craig Smith, Tim Stutzle, Frank Vatrano, Owen Tippett, Owen Tippett, James Neal, Phillip Danault, Zack Kassian, Ryan Dzingel
Custom OT Lines Defensemen
John Carlson, Mark Giordano, Jordan Oesterle, Brendan Smith, Matt Grzelcyk
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
News Database File Not Found. Please create one from the League News Management or the STHS.
[2022-09-26 14:47:46] - Brampton Battalion hired Bob Woods for 72 600 $ for 1 year(s). [2022-09-23 15:55:00] - Sam Anas signed with Oilers for 700 000 $ for 1 year(s) / Option : No Trade. [2022-09-23 15:55:00] - Sam Anas was added to Oilers. [2022-09-19 15:14:57] - Dylan McIlrath signed with Oilers for 700 000 $ for 1 year(s) / Option : No Trade. [2022-09-19 15:14:57] - Dylan McIlrath was added to Oilers. [2022-09-16 14:55:47] - Dmitrij Jaskin was added to Oilers. [2022-09-16 14:55:33] - Chris Terry was added to Oilers. [2022-09-16 14:55:18] - Gregory Hofmann was added to Oilers. [2022-09-16 14:54:07] - TRADE : From Lightning to Oilers : Ryan Dzingel (64). [2022-09-10 15:31:06] - Oilers drafts Ben Strinden as the #220 overall pick in the Entry Draft of year 2022. [2022-09-10 14:29:59] - Evan Nause has been deleted from Oilers. [2022-09-05 16:52:52] - TRADE : From Predators to Oilers : Y:2023-RND:3-CAL. [2022-09-05 16:52:52] - TRADE : From Oilers to Predators : Kyle Okposo (72), Y:2023-RND:6-SEA. [2022-08-09 12:53:10] - Oilers drafts Simon Forsmark as the #92 overall pick in the Entry Draft of year 2022. [2022-08-09 12:45:57] - Oilers drafts Adam Ingram as the #74 overall pick in the Entry Draft of year 2022. [2022-08-09 12:27:04] - Tristin Langan was added to Oilers. [2022-08-02 10:25:06] - TRADE : From Islanders to Oilers : Y:2022-RND:7-LAK. [2022-07-24 14:40:52] - TRADE : From Maple Leafs to Oilers : Y:2022-RND:3-TOR. [2022-07-24 14:40:52] - TRADE : From Oilers to Maple Leafs : Y:2022-RND:3-STL, Y:2022-RND:5-DET. [2022-07-23 10:52:11] - Oilers drafts Sam Rinzel as the #42 overall pick in the Entry Draft of year 2022. [2022-07-23 10:47:29] - Oilers drafts Julian Lutz as the #39 overall pick in the Entry Draft of year 2022. [2022-07-23 10:34:52] - Oilers drafts Jiri Kulich as the #21 overall pick in the Entry Draft of year 2022. [2022-07-23 10:30:53] - Oilers drafts Cutter Gauthier as the #5 overall pick in the Entry Draft of year 2022. [2022-07-23 10:25:33] - Ryan Chyzowski was added to Oilers. [2022-07-18 17:33:08] - Brampton Battalion hired Paul Maurice for 1 079 925 $ for 1 year(s). [2022-07-18 17:33:07] - Brampton Battalion fired Pascal Vincent. [2022-07-17 09:41:15] - TRADE : From Oilers to Lightning : Martin Kaut (60), Morgan Geekie (63), Y:2022-RND:1-LAK. [2022-07-17 09:41:15] - TRADE : From Lightning to Oilers : Phillip Danault (74). [2022-07-17 09:28:01] - TRADE : From Oilers to Blue Jackets : Y:2022-RND:2-PHI, Y:2022-RND:4-NYI. [2022-07-17 09:28:01] - TRADE : From Blue Jackets to Oilers : Frank Vatrano (67). [2022-07-12 17:29:53] - TRADE : From Oilers to Canucks : Luke Schenn (71), Y:2022-RND:1-HAR. [2022-07-12 17:29:53] - TRADE : From Canucks to Oilers : Matt Grzelcyk (66), Y:2022-RND:1-VAN. [2022-07-08 15:53:38] - TRADE : From Oilers to Islanders : Tomas Nosek (66), Cam Dineen (62). [2022-07-08 15:53:38] - TRADE : From Islanders to Oilers : Craig Smith (69). [2022-06-21 16:55:28] - James Sanchez has been added to Oilers. [2022-06-21 16:53:07] - Ryan O'Rourke has been added to Oilers. [2022-06-21 16:52:48] - Jake Gardiner was added to Oilers. [2022-06-07 14:37:11] - TRADE : From Canadiens to Oilers : Rasmus Asplund (64), Y:2022-RND:3-LAK. [2022-06-07 14:37:11] - TRADE : From Oilers to Canadiens : Jeff Skinner (74). [2022-06-07 14:26:15] - Matthew Villalta was added to Oilers.
[2022-10-07 12:22:30] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-10-06 17:01:27] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-10-05 08:27:39] Kaapo Kahkonen from Oilers is back from Sore Left Knee Injury.
[2022-10-05 08:27:19] Dylan McIlrath(Oilers) cleared from waivers and was sent to down farm.
[2022-10-05 08:27:19] Dmitrij Jaskin(Oilers) cleared from waivers and was sent to down farm.
[2022-10-05 08:27:19] Game 187 - Kaapo Kahkonen from Oilers is injured (Sore Left Knee) and is out for 6 days.
[2022-10-05 08:27:13] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-10-05 08:25:15] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.
[2022-10-05 08:25:14] Dylan McIlrath of Oilers was sent down to farm.
[2022-10-05 08:25:13] Oilers placed Dylan McIlrath on waivers.
[2022-10-05 08:25:13] Dmitrij Jaskin of Oilers was sent down to farm.
[2022-10-05 08:23:50] Oilers placed Dmitrij Jaskin on waivers.
[2022-10-04 13:20:42] Matthew Villalta from Brampton Battalion is back from Left Foot Injury.
[2022-10-04 13:20:42] Jordan Oesterle from Oilers is back from Bruised Left Shoulder Injury.
[2022-10-04 13:20:42] Paul Cotter of Oilers was sent to farm.
[2022-10-04 13:20:42] Frederik Gauthier of Oilers was sent to farm.
[2022-10-04 13:20:42] Philip Broberg of Oilers was sent to farm.
[2022-10-04 13:20:42] Cody Glass of Oilers was sent to farm.
[2022-10-04 13:20:40] Farm Game #148 - Kristian Vesalainen from Brampton Battalion has scored a Hat Trick!
[2022-10-04 13:20:40] Farm Game #148 - Chris Terry from Brampton Battalion has scored a Hat Trick!
[2022-10-04 13:20:40] Farm Game #148 - Sam Anas from Brampton Battalion has scored a Hat Trick!
[2022-10-04 13:20:36] Auto Lines Function has been run for Oilers.
[2022-10-04 13:20:36] Auto Roster Partial Function has been run for Oilers.
[2022-10-04 13:20:36] Dylan McIlrath of Oilers was sent to pro.
[2022-10-04 13:20:36] Paul Cotter of Oilers was sent to pro.
[2022-10-04 13:20:36] Dmitrij Jaskin of Oilers was sent to pro.
[2022-10-04 13:20:36] Frederik Gauthier of Oilers was sent to pro.
[2022-10-04 13:20:36] Philip Broberg of Oilers was sent to pro.
[2022-10-04 13:20:36] Cody Glass of Oilers was sent to pro.
[2022-10-04 13:20:13] Game 156 - Jordan Oesterle from Oilers is injured (Bruised Left Shoulder) and is out for 1 week.
[2022-10-04 13:19:57] Successfully loaded Oilers lines done with Web Base Client and SQLite Database.