| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Al Arbour | New York Islanders | 50 | 50 | 70 | 50 | 60 | 60 | 40 | CAN | 56 | 1 | 50,000$ | |
| Barry Long | Winnipeg Jets | 60 | 50 | 50 | 60 | 50 | 50 | 60 | CAN | 39 | 1 | 50,000$ | |
| Bob Berry | Pittsburgh Penguins | 60 | 50 | 50 | 60 | 50 | 50 | 50 | CAN | 45 | 1 | 50,000$ | |
| Bob Johnson | Calgary Flames | 50 | 60 | 70 | 60 | 60 | 60 | 30 | USA | 57 | 1 | 50,000$ | |
| Bob Pulford | Chicago Blackhawks | 60 | 50 | 50 | 50 | 60 | 60 | 40 | CAN | 52 | 1 | 50,000$ | |
| Dan Maloney | Toronto Maple Leafs | 60 | 50 | 60 | 50 | 50 | 50 | 70 | CAN | 38 | 1 | 50,000$ | |
| Don Cherry | Boston Bruins | 50 | 60 | 50 | 60 | 60 | 60 | 30 | CAN | 54 | 1 | 50,000$ | |
| Doug Carpenter | New Jersey Devils | 60 | 60 | 50 | 50 | 50 | 50 | 50 | CAN | 46 | 1 | 50,000$ | |
| Harry Neale | St-Louis Blues | 50 | 50 | 50 | 50 | 60 | 60 | 40 | CAN | 51 | 3 | 50,000$ | |
| Herb Brooks | Hartford Whalers | 60 | 60 | 60 | 70 | 60 | 70 | 50 | USA | 51 | 4 | 50,000$ | |
| Jacques Demers | Detroit Red Wings | 50 | 50 | 50 | 70 | 50 | 50 | 50 | CAN | 44 | 3 | 50,000$ | |
| Jean Perron | Montreal Canadiens | 50 | 60 | 60 | 50 | 50 | 50 | 50 | CAN | 42 | 1 | 50,000$ | |
| John Muckler | Edmonton Oilers | 50 | 60 | 60 | 60 | 60 | 60 | 30 | CAN | 54 | 1 | 50,000$ | |
| Lorne Henning | Minnesota North Stars | 50 | 50 | 60 | 50 | 50 | 50 | 60 | CAN | 36 | 1 | 50,000$ | |
| Michel Bergeron | Quebec Nordiques | 50 | 50 | 50 | 60 | 50 | 50 | 70 | CAN | 42 | 1 | 50,000$ | |
| Mike Keenan | Philadelphia Flyers | 60 | 50 | 50 | 70 | 50 | 50 | 50 | CAN | 39 | 1 | 50,000$ | |
| Pat Burns | Washington Capitals | 70 | 50 | 50 | 70 | 50 | 50 | 70 | CAN | 36 | 4 | 50,000$ | |
| Pat Quinn | Los Angeles Kings | 60 | 60 | 50 | 50 | 50 | 50 | 50 | CAN | 45 | 1 | 50,000$ | |
| Scotty Bowman | Buffalo Sabres | 50 | 60 | 70 | 60 | 70 | 70 | 40 | CAN | 55 | 1 | 50,000$ | |
| Ted Sator | New York Rangers | 50 | 60 | 60 | 50 | 50 | 50 | 60 | USA | 39 | 1 | 50,000$ | |
| Tom Watt | Vancouver Canucks | 50 | 50 | 50 | 50 | 70 | 60 | 40 | CAN | 53 | 1 | 50,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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bill Dineen | Adirondack Red Wings | 50 | 50 | 50 | 60 | 60 | 50 | 50 | CAN | 56 | 1 | 25,000$ | |
| Bill Laforge |  Hamilton Canucks | 50 | 50 | 50 | 50 | 50 | 50 | 70 | CAN | 37 | 1 | 25,000$ | |
| Claire Alexander |  St. Catharines Saints | 60 | 60 | 50 | 50 | 50 | 50 | 50 | CAN | 43 | 1 | 25,000$ | |
| Cliff Koroll |  Milwaukee Admirals | 50 | 50 | 60 | 50 | 50 | 50 | 60 | CAN | 42 | 1 | 25,000$ | |
| Earl Jessiman |  Fredericton Express | 50 | 50 | 50 | 60 | 50 | 50 | 60 | CAN | 33 | 1 | 25,000$ | |
| Fred Creighton |  Springfield Indians | 50 | 50 | 50 | 50 | 60 | 60 | 40 | CAN | 58 | 1 | 25,000$ | |
| Gene Ubriaco |  Baltimore Skipjacks | 50 | 50 | 50 | 50 | 60 | 60 | 40 | CAN | 51 | 1 | 25,000$ | |
| Joe Crozier |  Rochester Americans | 50 | 50 | 50 | 50 | 70 | 60 | 40 | CAN | 59 | 1 | 25,000$ | |
| John Ferguson |  Manitoba Moose | 60 | 60 | 50 | 60 | 60 | 60 | 30 | CAN | 50 | 1 | 25,000$ | |
| John Paddock |  Philadelphia Phantoms | 50 | 50 | 60 | 50 | 50 | 50 | 50 | CAN | 34 | 1 | 25,000$ | |
| Larry Kish |  Nova Scotia Oilers | 50 | 50 | 50 | 60 | 50 | 50 | 60 | CAN | 47 | 1 | 25,000$ | |
| Larry Pleau |  Binghamton Whalers | 50 | 60 | 60 | 50 | 50 | 50 | 60 | USA | 41 | 1 | 25,000$ | |
| Nick Beverley |  New Haven Nighthawks | 50 | 50 | 50 | 50 | 50 | 50 | 60 | CAN | 41 | 1 | 25,000$ | |
| Pat Kelly |  Peoria Rivermen | 50 | 50 | 50 | 50 | 70 | 60 | 40 | CAN | 53 | 1 | 25,000$ | |
| Pierre Creamer |  Sherbrooke Canadiens | 50 | 50 | 50 | 50 | 50 | 50 | 60 | CAN | 44 | 1 | 25,000$ | |
| Rick Bowness |  Moncton Golden Flames | 50 | 50 | 60 | 50 | 50 | 50 | 70 | CAN | 33 | 1 | 25,000$ | |
| Rob Laird |  Fort Wayne Komets | 50 | 50 | 50 | 60 | 50 | 50 | 60 | CAN | 34 | 1 | 25,000$ | |
| Roger Neilson |  Hartford Wolf Pack | 50 | 60 | 50 | 60 | 50 | 50 | 50 | CAN | 54 | 1 | 25,000$ | |
| Ron Ullyot |  Indianapolis Checkers | 50 | 50 | 50 | 50 | 50 | 50 | 70 | CAN | 42 | 1 | 25,000$ | |
| Terry Crisp |  Providence Bruins | 50 | 50 | 50 | 60 | 50 | 50 | 60 | CAN | 45 | 1 | 25,000$ | |
| Tom McVie |  Maine Mariners | 50 | 50 | 50 | 50 | 60 | 60 | 40 | CAN | 53 | 1 | 25,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 | PH | DF | OF | PD | EX | LD | PO | CNT | Age | Contract | Contrat Signature Date | Salary |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bryan Murray | 50 | 60 | 60 | 50 | 50 | 50 | 50 | CAN | 46 | 1 | 50,000$ | |
| Jack Evans | 50 | 50 | 50 | 60 | 80 | 70 | 30 | ENG | 60 | 1 | 50,000$ |