Search

in the html type columns). Then the sorting would

to filter on individual columns, but I am creating

It seems to happen on the following line: oSettings.aiDisplayMaster.sort(fnLocalSorting) It's always the same columns in my table but there appears to be nothing special about the data in those specific columns. Thanks Chris

Spot on. Thanks for the update post :) Allan

One option is to set the page.len() to -1 to fetch all the data from the server to allow Datatables to perform the filtering. Although this negates enabling server side processing in the first place. The best option is to gather the filtering info you are interested in and sending it via jQuery Ajax() to the server then have the server script gather the coordinate info to return in the JSON response. In the success function handle the JSON response as appropriate. The plugin mentioned in the Buttons SSP FAQ does something similar to allow for server side exporting of the filtered data. You might be able to leverage it and add the searchBuilder.getDetails() details to perform your search. It will need refactoring to fit into your requirements. Or maybe it will help get you started with your own Ajax request parameters. Kevin

Thank you Allan! That would be great!

Link to test case: Debugger code (debug.datatables.net): Error messages shown: None Description of problem: I added column filtering and set it up in "initComplete" section. I also defined a div that contains a drop down list to allow users to filter based on one column. The problem I am facing is one or the other shows up depending on how I declare the datatable. If I add the declaration in a function, say "bindMyDatatable()" and call it in document.ready portion, then column filtering appears but drop down won't. If I remove the function name and just declare the data table definition, then drop down (custom DOM) appears but column filtering won't. Not sure how to fix it. $(documet).ready(function(){ ... $("div.toolbar").html('markup for drop down'); // setup column filtering $('#MyTable thead tr') .clone(true) .addClass('filters'). .appendTo('#MyTable thead'); bindMyTable(); ... }); function bindMyTable(){ tblMyTable = $("MyTable").DataTable({ ... dom:<'row'<col-md-2' l><'col-md-2'<\"toolbar\">><...>>"; ... initCompleter: function(){ ... } }); This shows column filtering but not drop down in custom DOM. If I comment out bindMyTable in document.ready, and remove "function bindMyTable(){" and just leave table definition, then custom DOM appears but column filtering won't.

Hi. This is already fixed in a recent commit.

It would be helpful if you filled in the text with a bit more of a description of what you want to do. Is it like this but with multiple for the select elements? Have you taken a look at SearchPanes? Allan

It will work until the end user changes the value. If that is a consideration, you might want to add the event listener. Allan