Yet Another DataTables Column Filter (yadcf) 0.9.3.beta

DOM source with chosen example

This jQuery plug-in allows the user to easily add filter components to table columns, the plug-in works on top of the DataTables jQuery plug-in.

Downloads Change log

Some Data	Numbers	Country	Values	Tags
Some Data 1	1000	United States	a_value,b_value	Tag1Tag2
Some Data 2	22	United Kingdom	b_value,c_value	Tag1Tag3
Some Data 3	33	Russia	a_value	Tag2Tag3
Some Data 4	44	Aland Islands	b_value	Tag2
Some Data 5	55	Chile	a_value,b_value	Tag1Tag2
Some Data 1	111	China	c_value,d_value	Tag2
Some Data 2	222	Russia	e_value,f_value	Tag3Tag4Tag5
Some Data 3	33	Ukraine	a_value,bb_value	Tag5
Some Data 4	444	Senegal	a_value,f_value	Tag4
Some Data 55	55	Russia	a_value,c_value	Tag1Tag2
Some Data 1	300	Russia	a_value,b_value	Tag1Tag3
Some Data 2	242	Ukraine	d_value,aa_value	Tag1
Some Data 3	703	United Kingdom	a_value,c_value	Tag1Tag2
Some Data 4	604	United Kingdom	a_value,bb_value	Tag1Tag2
Some Data 5	550	United States	c_value,e_value	Tag2
Some Data 1	901	United States	a_value,e_value	Tag1

Features:

Support DataTables 1.10.0 - Use yadcf.init(...) for new API (Capital "D")
Support all data source: DOM, Javascript, Ajax and server-side processing (1.10.0 +)
Various filter options - 9 different types !!! :
- select input
- multiple selection input
- text input
- autocomplete input - make use of the jQuery UI Autocomplete widget (with some enhancements)
- date input - make use of the jQuery UI Datepicker widget (with some enhancements)
- range of numbers
- range of numbers with slider widget - make use of the jQuery UI Slider widget (with some enhancements)
- range of dates - make use of the jQuery UI Datepicker widget (with some enhancements)
- custom function
Filters can be placed in the header (thead) or in the footer (tfoot) , second argument of yadcf constructor or third argument of init function
Parsing various types of columns:
- plain text
- plain text with delimiter
- one or more HTML elements with the ability to extract text / value / id from each HTML element
Multiple tables support
CSS support:
- each filter element has got a css style class , so its style can be easily overridden
Reset button for filter:
- next to each filter a reset button will appear (this button allows the user to reset the filter)
Filter in use visual notification:
- when a certain filter is being used it will be highlighted (the color of highlight can easily be changed with css)
Miscellaneous:
- integration with the Chosen / Select2 plugins (for single and multiple select)
- integration with the Datatables ColVis plugin (1.10.0 +)
- filter delay (for text / range_number / range_date filters / range_number_slider)
- predefined data source for filter (array of strings or objects)
- mData support (including deeply nested objects)
- ability to place the filter in an external html element (for example: inside a div element)
- ability to control matching mode of the filter (Possible values: contains / exact / startsWith)
- change the filter's default label (Select value, etc)
- change the filter's reset button text (x, clear etc)
- define how the values in the filter will be sorted
- define the order in which the values in the filter will be sorted
- support all major browser (including IE8)
- define in which date format the date will be parsed and displayed in datepicker widget
- support aoColumns { "bVisible": false }
- support for case sensitive filtering
- allow addition of classes to filters
External API functions:
- exFilterColumn: Allows to trigger filter/s externally/programmatically (support ALL filter types!!!) , perfect for showing table with pre filtered columns
- exGetColumnFilterVal: Allows to retrieve column current filtered value (support ALL filter types!!!)
- exResetAllFilters: Allows to reset all filters externally/programmatically (support ALL filter types!!!) , perfect for adding a "reset all" button to your page!
Notable datatables API / Features support
- ColReorder / scrollX / scrollY / stateSave / deferRender / HTML5 data-* attributes / Complex headers

Usage(on this page example):

						$(document).ready(function () {
						    'use strict';
						    
						    //----------------------------------------------
					    	//note that this is the old yadcf API for init the filters 
					    	//new init function should be used when working with new Datatable (capital "D" API)
					    	//for new init function see: http://yadcf-showcase.appspot.com/DOM_Ajax_Multiple_1.10.html
					    	//----------------------------------------------
					    
						    oTable = $('#example').dataTable({
						        "bStateSave": true
						    }).yadcf([{
						        column_number: 0,
						        filter_type: "multi_select",
						        select_type: 'chosen'
						    }, {
						        column_number: 1,
						        filter_type: "range_number"
						    }, {
						        column_number: 2,
						        select_type: 'chosen',
						        select_type_options: {
						            no_results_text: 'Can\'t find ->',
						            search_contains: true
						        }
						    }, {
						        column_number: 3,
						        filter_type: "auto_complete",
						        text_data_delimiter: ","
						    }, {
						        column_number: 4,
						        select_type: 'chosen',
						        select_type_options: {
						            disable_search: true
						        },
						        column_data_type: "html",
						        html_data_type: "text",
						        filter_default_label: "Select tag"
						    }]);
						
						    SyntaxHighlighter.all();
						});