Help with Column Filtering / sorting

zibzab

Hi, I love data tables and have somehow managed to integrate it into my site with table tools!
I say this, because my knowledge of web stuff is pretty poor, so I am impressed I have managed to do this!

However, I am now stuck with trying to turn off column filtering. I'll try and explain what I'm attempting.
I'm using data-tables with formidable pro forms (in wordpress).

I have a table that shows all the entries, you can then click on a link an it takes you to a table with detailed data in which allows you to use table tools for exporting. However, I want to turn off column filtering so that the exports are always in the same order (fixed).

Everything works so far apart from locking the columns. Below is my initialization script. Can this be adjusted to lock the columns (there are 2 columns, Field & Data).

[code]$(document).ready( function () {
$('#table_id').dataTable( {
"aaSorting": [[ 10, "desc" ]],
"bJQueryUI": true,
"iDisplayLength": 15,
"aLengthMenu": [[15, 25, 50, 100], [15, 25, 50, 100]],
"sPaginationType": "full_numbers", // [Edit: forgot the comma here when first posted]
"oLanguage": {
"sSearch": "Filter: "
},
"sDom": 'T<"clear">lfrtip',
"oTableTools": {
"sSwfPath": "weburl/swf/copy_csv_xls_pdf.swf",
"abuttons": [
"copy",
"csv",
"xls",
"pdf",
{ "type": "print", "buttonText": "Print me!" }
]
}
} );
} );[/code]

Thanks

zibzab

Hi, can anyone help with this - it would be much appreciated.
Cheers