Table Filters

Filtering Options

Filter Options

Use filters to below options to change the focus of your results in following data table

Publication date

Start date

End date

Data Type All news types News Releases Backgrounders Media Advisories Speeches Statements

Department From any department Agriculture and Agri-Food Canada Atlantic Canada Opportunities Agency Canadian Heritage Infrastructure Canada Innovation, Science and Economic Development Canada National Defence and the Canadian Armed Forces Employment and Social Development Canada Global Affairs Canada Indigenous and Northern Affairs Canada Competition Bureau Canadian Grain Commission National Energy Board Canadian Radio-television and Telecommunications Commission Public Health Agency of Canada Correctional Service Canada Parks Canada Veterans Affairs Canada Health Canada National Film Board Government of Canada Federal Economic Development Agency for Southern Ontario Canadian Environmental Assessment Agency Fisheries and Oceans Canada Canadian Institutes of Health Research Transportation Safety Board of Canada Canadian Nuclear Safety Commission Transport Canada Service Canada Treasury Board of Canada Secretariat Environment and Climate Change Canada Finance Canada Canada Economic Development for Quebec Regions

Minister Related to any minister Hon. Lawrence MacAulay Hon. Navdeep Singh Bains Hon. Amarjeet Sohi Hon. Kirsty Duncan Hon. Jean-Yves Duclos Hon. Stéphane Dion Hon. Carolyn Bennett Hon. Jane Philpott Hon. MaryAnn Mihychuk Hon. Ralph Goodale Hon. Catherine McKenna Hon. Kent Hehr Hon. Harjit Singh Sajjan Hon. Dominic LeBlanc Hon. Mélanie Joly Hon. Marc Garneau Hon. Scott Brison Hon. Marie-Claude Bibeau Hon. William Francis Morneau Right Hon. Justin P. J. Trudeau

For

• Everyone
• Media
• Farmers
• General Public
• Rural Community
• Travellers
• Visitors
• Business
• Students
• Parents
• Youth
• Employers
• Job Seekers
• Government
• Scientists
• Veterans
• Seniors
• Children
• Educators
• Aboriginal Peoples
• Non-Governmental Organizations

Location

• Anywhere
• Manitoba
• Canada
• Nova Scotia
• Alberta
• Ontario
• Newfoundland and Labrador
• New Brunswick
• Saskatchewan
• British Columbia
• Quebec
• Yukon Territory
• Prince Edward Island

Advanced Options

Any

Both

Either

And

Filter

Reset to defaults

Title	Publication date	Department	News Type	Summary	Location	For	Subject	Minister

Creating Date Range, Drop-Down List and/or Checkbox Filters

1. Create a <form> with the following attributes class="wb-tables-filter" and data-bind-to="TABLE_ID".

2. For date range create two date inputs (<input type="date"/>) add the following attribute data-column="COLUMN_NUMBER"

   Example: <input type="date" class="form-control" id="dt_mindate" name="dt_mindate" data-column="1"/>

   Each date input requires the same column number. Please note that the column numbers start at 0.

3. For drop-down list create a select list (<select>) add the following attribute data-column="COLUMN_NUMBER"

   Only assign one drop-down list a single column number (no duplicates). Please note that the column numbers start at 0.

4. For checkboxes create a checkbox list (<input type="checkbox">) assign each the following attribute data-column="COLUMN_NUMBER"

   Each checkbox requires the same column number. Please note that the column numbers start at 0.

Accepted Formats for Date Range

Currently only accepts ISO 8601 (YYYY-MM-DD). See examples below.

• 2016-07-26T14:07:00
• 2016-07-26 14:07:00
• 2016-07-26

Advanced Options For Checkboxes

Allows the user to change how checkboxes are filtered (default is ANY).

1. Add data-aopts='{"type": "", "column": ""}' arrtibute to any radio element to apply the advanced options.
2. Available filter types:
   1. ANY - This option will return entries that contain either A or B, or both.
   2. BOTH - This option will only return entries that contain both A and B.
   3. EITHER - This option will return all entries that are just A or just B - and not combinations of the two.
   4. AND - This option will only return entries that are a combination of A or B.
3. Column is the checkboxes that the filter well apply too (must match there 'data-column').

<label for="dt_location_aopts1"><input type="radio" name="dt_location_aopts" id="dt_location_aopts1" data-aopts='{"type": "any", "column": "5"}' checked />Any</label>

Filtering Options

Filter Options

Use filters to below options to change the focus of your results in following data table

Age

Min

Max

Advanced Options

Either

And

Salary

Min

Max

Taxes

Min

Max

Filter

Reset to defaults

Id	First Name	Last Name	Age	Salary	Taxes

Creating Number Range Filters

1. Create a <form> with the following attributes class="wb-tables-filter" and data-bind-to="TABLE_ID".

2. Create two number fields (<input type="number">) assign each the following attribute data-column="COLUMN_NUMBER".

   Each number field requires the same column number. Please note that the column numbers start at 0.

Advanced Options For Number Range

Allows the user to change how number range is filtered (default is EITHER).

1. Add data-aopts='{"type": "", "column": ""}' arrtibute to any radio element to apply the advanced options.
2. Available filter types:
   1. EITHER - This option will return all entries that are either equal to/greater then A OR/AND equal to/less then B.
   2. AND - This option will only return entries that are equal to/greater then A AND equal to/less then B.
3. Column is the number range that the filter well apply too (must match there 'data-column').

<label for="dt_age_aopts1"><input type="radio" name="dt_age_aopts" id="dt_age_aopts1" data-aopts='{"type": "either", "column": "5"}' checked />Either</label>

Filtering Options

Filter Options

Use filters to below options to change the focus of your results in following data table

Age

Age

Name

First Name

Last Name

Filter

Reset to defaults

Id	First Name	Last Name	Age	Salary	Taxes