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 |
# | Player | Team | Position | Height | Weight | Age | Born | Birthplace | Condition | Contract |
---|---|---|---|---|---|---|---|---|---|---|
37 | Patrice Bergeron | C | 6' 1" | 195 | 37 | July 24, 1985 | CAN | 100.00 | 7,707,000$/2yrs | |
21 | Scott Laughton | C | 6' 1" | 190 | 29 | May 30, 1994 | CAN | 100.00 | 2,968,200$/5yrs | |
0 | Jakub Voracek | LW/RW | 6' 2" | 209 | 33 | August 15, 1989 | CZE | 100.00 | 7,098,000$/3yrs | |
14 | Adam Henrique | C | 6' 0" | 195 | 33 | February 06, 1990 | CAN | 100.00 | 5,346,000$/3yrs | |
5 | Nate Schmidt | D | 6' 0" | 194 | 31 | July 16, 1991 | USA | 100.00 | 5,459,250$/4yrs | |
21 | David Backes | C/RW | 6' 3" | 215 | 39 | May 01, 1984 | USA | 100.00 | 2,196,000$/1yrs | |
27 | Gaetan Haas | C | 6' 0" | 181 | 31 | January 31, 1992 | CHE | 100.00 | 850,000$/1yrs | |
28 | Loui Eriksson | LW | 6' 2" | 179 | 37 | July 17, 1985 | SWE | 100.00 | 992,000$/1yrs | |
34 | Tom Kuhnhackl | LW/RW | 6' 2" | 190 | 31 | January 21, 1992 | DEU | 100.00 | 966,000$/1yrs | |
23 | Tobias Rieder | C/LW/RW | 5' 11" | 189 | 30 | January 10, 1993 | DEU | 100.00 | 1,172,000$/1yrs | |
11 | Andrew Ladd | LW | 6' 3" | 205 | 37 | December 12, 1985 | CAN | 100.00 | 3,153,000$/2yrs | |
16 | Troy Stecher | D | 5' 10" | 184 | 29 | April 07, 1994 | CAN | 100.00 | 1,406,500$/2yrs | |
0 | Mikko Lehtonen | D | 6' 0" | 196 | 29 | January 16, 1994 | FIN | 100.00 | 1,000,000$/1yrs | |
91 | Kristian Vesalainen (R) | LW | 6' 3" | 207 | 24 | June 01, 1999 | FIN | 100.00 | 1,528,000$/1yrs | |
92 | Joe Snively | C | 5' 9" | 176 | 27 | January 01, 1996 | USA | 100.00 | 785,000$/3yrs | |
55 | Johnny Boychuk | D | 6' 2" | 227 | 39 | January 19, 1984 | CAN | 100.00 | 2,550,000$/1yrs |