Search

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

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

I have a table that by default is ordered by column 16 descending. If a user clicks on a second column, how do I keep column 16 as a secondary order? For example, if column 16 is number of 'Goals' scored by a list of football players, and then the user chooses to order a second column in that table called 'Appearances', assuming several players have made the same amount of appearances, how do you make them ordered by goals scored?

how to replace text ''software'' to ''hardware'' or more simply like ''soft'' to ''hard'' from column POSITION and also ''york'' to ''jersey'' from column OFFICE https://live.datatables.net/wegarezi/13/edit

It is somewhat counter intuitive that option. It should really be a column property... One for an update sometime! Good to hear you found the answer. Allan

Can you link to a test case showing the issue please? Thanks, Allan

Yes, style="width: 100%" is currently required for DataTables to do its dynamic column widths. That will change with 2.1, which will automatically add 100% width as a style (and thus do the dynamic column widths) if an existing style or attribute width is not found. Allan