TableTools and ColumnFilter (remove footer)
TableTools and ColumnFilter (remove footer)
zxarr
Posts: 12Questions: 1Answers: 0
Hello,
I am using a pretty basic datatables table with table tools (love it!) which works well, however when using the columnfilter plugin, the footer is always displayed with the entire dropdown list in the output file.
So the question is: can you tell table tools to ignore the footer?
[code]
$(document).ready(function() {
$('#t_opencases').dataTable(
{
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "../swf/copy_csv_xls_pdf.swf"
},
"sAjaxSource": "process_managementconsole.php?action=assigned",
"sPaginationType": "full_numbers",
"iDisplayLength": 50,
"aLengthMenu": [
[50, 100, -1],
["50", "100", "All"]
],
"aoColumns": [
{ "sName": "id", "sTitle": "ID", "sWidth": "5%" },
{ "sName": "caseid", "sTitle": "CaseID", "sWidth": "16%" },
{ "sName": "status","sTitle": "Status" },
{ "sName": "priority","sTitle": "Priority" },
{ "sName": "assignee","sTitle": "Assignee", "sWidth": "12%" },
{ "sName": "region", "sTitle": "Region" },
{ "sName": "created", "sTitle": "Created", "sWidth": "16%" },
{ "sName": "owner", "sTitle": "Owner", "sWidth": "12%" },
{ "sName": "sstatus", "sTitle": "Search Status" }
],
})
.columnFilter({
aoColumns: [
null,
null,
{ type: "select" },
{ type: "select" },
{ type: "select" },
{ type: "select" },
{ type: "Date" },
{ type: "select" },
{ type: "select" }
]
})
});
[/code]
I am using a pretty basic datatables table with table tools (love it!) which works well, however when using the columnfilter plugin, the footer is always displayed with the entire dropdown list in the output file.
So the question is: can you tell table tools to ignore the footer?
[code]
$(document).ready(function() {
$('#t_opencases').dataTable(
{
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "../swf/copy_csv_xls_pdf.swf"
},
"sAjaxSource": "process_managementconsole.php?action=assigned",
"sPaginationType": "full_numbers",
"iDisplayLength": 50,
"aLengthMenu": [
[50, 100, -1],
["50", "100", "All"]
],
"aoColumns": [
{ "sName": "id", "sTitle": "ID", "sWidth": "5%" },
{ "sName": "caseid", "sTitle": "CaseID", "sWidth": "16%" },
{ "sName": "status","sTitle": "Status" },
{ "sName": "priority","sTitle": "Priority" },
{ "sName": "assignee","sTitle": "Assignee", "sWidth": "12%" },
{ "sName": "region", "sTitle": "Region" },
{ "sName": "created", "sTitle": "Created", "sWidth": "16%" },
{ "sName": "owner", "sTitle": "Owner", "sWidth": "12%" },
{ "sName": "sstatus", "sTitle": "Search Status" }
],
})
.columnFilter({
aoColumns: [
null,
null,
{ type: "select" },
{ type: "select" },
{ type: "select" },
{ type: "select" },
{ type: "Date" },
{ type: "select" },
{ type: "select" }
]
})
});
[/code]
This discussion has been closed.
Replies
[code]
$(document).ready(function() {
$('#t_opencases').dataTable(
{
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "../swf/copy_csv_xls_pdf.swf",
"aButtons": [
{
"sExtends": "copy",
"sButtonText": "Copy to Clipboard",
"bFooter": false
},
{
"sExtends": "xls",
"sButtonText": "Export to Excel",
"bFooter": false
},
{
"sExtends": "pdf",
"sButtonText": "Export to PDF",
"bFooter": false
}
]
},
"sAjaxSource": "process_managementconsole.php?action=assigned",
"sPaginationType": "full_numbers",
[/code]
Reading manuals is a good thing. :)