| 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 |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alexei Kovalev | Columbus Blue Jackets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 60 | 6 | 1,000,000$ | |
| Andrew Brunette | Atlanta Thrashers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 51 | 8 | 2024-07-22 | 1,000,000$ |
| Doug Gilmour | Hartford Whalers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 64 | 5 | 1,000,000$ | |
| Igor Larionov | Detroit Red Wings | 80 | 80 | 80 | 80 | 80 | 80 | 80 | RUS | 66 | 5 | 1,000,000$ | |
| Jari Kurri | California Golden Seals | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 66 | 5 | 1,000,000$ | |
| Jason Payne | Cincinnati Cyclones | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 42 | 7 | 750,000$ | |
| Jeremy Roenick | Kansas City Scouts | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 56 | 5 | 1,000,000$ | |
| Joel Quenneville | New Jersey Devils | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 71 | 7 | 1,000,000$ | |
| Jon Cooper | Anaheim Ducks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 65 | 6 | 1,000,000$ | |
| Marian Gaborik | San Jose Sharks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 44 | 6 | 1,000,000$ | |
| Marian Hossa | Chicago Blackhawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 47 | 5 | 1,000,000$ | |
| Mario Lemieux | Pittsburgh Penguins | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 61 | 6 | 1,000,000$ | |
| Mats Sundin | Toronto Maple Leafs | 80 | 80 | 80 | 80 | 80 | 80 | 80 | Swe | 56 | 5 | 1,000,000$ | |
| Michal Handzus | St Louis Blues | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SVK | 49 | 5 | 1,000,000$ | |
| Nicklas Lidstrom | Savannah Ghost Pirates | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 51 | 8 | 2024-07-22 | 1,000,000$ |
| Steve Yzerman | Tampa Bay Lightning | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 61 | 5 | 1,000,000$ | |
| Trevor Linden | Winnipeg Jets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 56 | 5 | 1,000,000$ |
| 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 |
| Coaches Name | Team Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alex Daigle |  Greenville Swamp Rabbits | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 51 | 5 | 1,000,000$ | |
| Chris Pronger |  O'Fallon Madcats | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 52 | 5 | 1,000,000$ | |
| Dan Bylsma |  Wheeling Nailers | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 59 | 6 | 1,000,000$ | |
| Daniel Sedin |  Sudbury Wolves | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 46 | 6 | 1,000,000$ | |
| Emilio Estevez |  San Diego Spartans | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 64 | 6 | 1,000,000$ | |
| Felix Potvin |  IUP Crimson Hawks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 54 | 5 | 1,000,000$ | |
| Jeff Blashill |  Orlando Solar Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 53 | 5 | 1,000,000$ | |
| Jerome Bechard |  Columbus River Dragons | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 42 | 7 | 750,000$ | |
| Kari Lehtonen |  Lillehammer IK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 42 | 6 | 1,000,000$ | |
| Kevin Dineen |  Utica Comets | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 66 | 6 | 1,000,000$ | |
| Marc Savard |  Jacksonville Lizard Kings | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 51 | 8 | 2024-07-22 | 1,000,000$ |
| Mike Rupp |  Cleveland Monsters | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 47 | 6 | 1,000,000$ | |
| Niklas Hjalmarsson |  Tucson Roadrunners | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 39 | 5 | 10,000,000$ | |
| Peter Forsberg |  Skelleftea AIK | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 53 | 5 | 1,000,000$ | |
| Rod Brind'Amour |  Saskatoon Blades | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 58 | 6 | 1,000,000$ | |
| Stan Smyl |  Calgary Canucks | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 5 | 1,000,000$ | |
| Tomas Holmstrom |  Sydney Ice Dogs | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 51 | 8 | 2024-07-22 | 1,000,000$ |
| Wayne Gretzky |  Hershey Bears | 80 | 80 | 80 | 80 | 80 | 80 | 80 | CAN | 68 | 6 | 1$ |
| 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 |
| Coaches Name | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Coach 1 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 2 | 1 | 2024-07-22 | 1,000,000$ |
| Coach 2 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | USA | 51 | 1 | 2024-07-22 | 1,000,000$ |
| Henrik Sedin | 80 | 80 | 80 | 80 | 80 | 80 | 80 | SWE | 46 | 7 | 1,000,000$ | |
| Saku Koivu | 80 | 80 | 80 | 80 | 80 | 80 | 80 | FIN | 51 | 0 | 2024-07-19 | 1,000,000$ |