columnFilter for dataTable no longer working???
columnFilter for dataTable no longer working???
I have a website that has been live for years where I am using the columnFilter to filter the data in my datatable.
Just recently, like the users reported TODAY, was that the filtering no longer worked. In IE developer tools, I get this error:
Object doesn't support property or method 'columnFilter'
Using google developer tools, the following shows:
Was there some update that is now causing an issue?
Here is the code for the page:
var oTable = $('#player_table').dataTable({
"bProcessing": true,
"bServerSide": true,
"stateSave": true,
"stateSave": true,
"sServerMethod": "GET",
"sAjaxSource": site_url + "backend/players/ajaxData",
"iDisplayLength": 10,
"aLengthMenu": [[10, 25, 50, - 1], [10, 25, 50, "All"]],
"aaSorting": [[0, 'desc']],
"sPaginationType": "full_numbers",
"dom": 'T<"clear">lfrtip',
tableTools: {
"sRowSelect": "",
"sSwfPath": site_url + "js/swf/copy_csv_xls_pdf.swf",
"aButtons": [
// "select_all", "select_none",
"copy",
"csv",
"xls",
{
"sExtends": "pdf",
"sTitle": "Report Name",
"sPdfMessage": "Summary Info",
"sPdfOrientation": "landscape",
"fnClick": function (nButton, oConfig, flash) {
customName = 'Player List' + ".pdf";
flash.setFileName(customName);
this.fnSetText(flash,
"title:" + 'Hurricane Junior Golf Tour Export' + "\n" +
"message:" + 'Player List' + "\n" +
"colWidth:" + this.fnCalcColRatios(oConfig) + "\n" +
"orientation:" + oConfig.sPdfOrientation + "\n" +
"size:" + oConfig.sPdfSize + "\n" +
"--/TableToolsOpts--\n" +
this.fnGetTableData(oConfig)
);
url = site_url + "backend/players/save_export";
// $.ajaxSetup({
// async: false
// });
$.post(url, {table: 'Player'});
// $.ajaxSetup({
// async: true
// });
}
},
"print"
],
},
"aoColumns": [
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": true, "bSortable": true},
{"bVisible": true, "bSearchable": false, "bSortable": false}]
});
oTable.columnFilter({
sRangeSeparator: "&%&",
sPlaceHolder: "head:before",
aoColumns: [
{type: "text"},
{type: "text"},
{type: "text"},
{type: "text"},
{type: "text"},
{type: "text"},
{type: "text"},
{type: "select", values: ['Junior', 'College', 'Amateur']},
{type: "text"},
{type: "text"},
{type: "text"},
{type: "text"},
{'sWidth': '200%', type: "date-range"},
null
]
});
Replies
More details from above....Right now, I am using this:
cdn.datatables.net/1.10.5 / js / jquery.dataTables.min.js
cdn.datatables.net/tabletools/2.2.0/ js/ dataTables.tableTools.min.js
But I've been using this for years