Yet Another DataTables Column Filter (yadcf) 0.9.3.beta

DOM / Ajax / Multiple 1.10.0 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

yadcf.initMultipleTables:

Some Data	Numbers	Dates	Values	Tags
Some Data 1	1000	01/24/2014	a_value,b_value	Tag1Tag2
Some Data 2	22	02/20/2014	b_value,c_value	Tag1Tag3
Some Data 3	33	02/26/2014	a_value	Tag2Tag3
Some Data 4	44	02/11/2014	b_value	Tag2
Some Data 5	55	02/29/2014	a_value,b_value	Tag1Tag2
Some Data 1	111	11/24/2014	c_value,d_value	Tag2
Some Data 2	222	02/03/2014	e_value,f_value	Tag3Tag4Tag5
Some Data 3	33	02/03/2014	a_value,bb_value	Tag5
Some Data 4	444	03/24/2014	a_value,f_value	Tag4
Some Data 5	55	03/22/2014	a_value,c_value	Tag1Tag2
Some Data 1	300	02/20/2014	a_value,b_value	Tag1Tag3
Some Data 2	242	02/04/2014	d_value,aa_value	Tag1
Some Data 3	703	02/05/2014	a_value,c_value	Tag1Tag2
Some Data 4	604	02/25/2014	a_value,bb_value	Tag1Tag2
Some Data 5	550	02/01/2014	c_value,e_value	Tag2
Some Data 1	901	02/02/2014	a_value,e_value	Tag1
Some Data 11	911	02/22/2014	a_value,e_value	Tag11

Rendering engine	Browser	Platform(s)	Engine version	CSS grade

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';
					
					    var oTable,
							oTable2;
					    
					    oTable = $('#example').DataTable({
							stateSave: true
					    });
					    
					    //----------------------------------------------
					    //notice the new yadcf API for init the filters:
					    //----------------------------------------------
					    
					    yadcf.init(oTable, [{
					        column_number: 0
					    }, {
					        column_number: 1,
					        filter_type: "range_number_slider"
					    }, {
					        column_number: 2,
					        filter_type: "date"
					    }, {
					        column_number: 3,
					        filter_type: "auto_complete",
					        text_data_delimiter: ","
					    }, {
					        column_number: 4,
					        column_data_type: "html",
					        html_data_type: "text",
					        filter_default_label: "Select tag"
					    }]);
					
					    oTable2 = $('#entrys_table').DataTable({
					    	"responsive": true,
					        "processing": true,
					        "ajax": "resources/sources/deep.txt",
					        "columns": [{
					            "data": "engine"
					        }, {
					            "data": "browser"
					        }, {
					            "data": "platform.inner"
					        }, {
					            "data": "platform.details.0"
					        }, {
					            "data": "platform.details.1"
					        }]
					    });
					    
					    //----------------------------------------------
					    //notice the new yadcf API for init the filters:
					    //----------------------------------------------
					    
					    yadcf.init(oTable2, [{
					        column_number: 0
					    }, {
					        column_number: 1,
			                filter_type: "text",
					        exclude: true,
					        exclude_label: '!(not)'
					    }, {
					        column_number: 2,
					        filter_type: "auto_complete"
					    }, {
					        column_number: 3,
					        filter_type: "range_number_slider",
					        ignore_char: "-"
					    }, {
					        column_number: 4
					    }]);
					    
					    yadcf.exFilterColumn(oTable2, [[0, "Misc"]]);
					    
					    
				    	yadcf.initMultipleTables([oTable, oTable2], [{
							filter_container_id: 'multi-table-filter',
							filter_default_label: 'Filter all tables!'
						}]);
					});