how integrate server side processing and jquery datatable column filter?

psarunkumar

Hi,

i use

jquery.dataTables.js Version: 1.10.4
dataTables.bootstrap.js Version: DataTables Bootstrap 3 integration
jquery.dataTables.columnFilter.js Version: 1.5.6.

my script

$('#dtable').dataTable({
            "paging":   true,
            "ordering": false,
            "info":     false,
            "processing": true,
            "serverSide": true, 
            "lengthMenu": [[25, 50, 100, -1], [25, 50, 100, "All"]],
            "fnDrawCallback": function( oSettings ) {
                $('#dtable tbody tr').each(function(){
                    $(this).find('td:eq(1)').attr('nowrap', 'nowrap');                  
                });         
            },
            "fnServerParams": function (aoData) {
                aoData.customstatusformsubmit = true;
            },
            "ajax": {
                "url": "http://localhost/testing/ajaxposttesting",
                "data": function ( d ) {
                    d.customstatusformsubmit = true;
                },
                "type": "POST"
            },
            "columns": [
                { "data": "data1" },
                { "data": "data2" },
                { "data": "data3" },
                { "data": "data4" },
                { "data": "data5" },
                { "data": "data6" },
                { "data": "data7" },
                { "data": "data9" },
                { "data": "data10" },
                { "data": "data11" },
                { "data": "data12" },
                { "data": "data13" },
                { "data": "data14" },
                { "data": "data15" },
                { "data": "data16" }
            ]           
            }).columnFilter({ 
                sPlaceHolder: "head:after",
                aoColumns: [ 
                { type: "date-range"},
                { type: "date-range" },
                { type: "text"},
                { type: "text"},
                { type: "text" },
                { type: "text" },
                { type: "text" },
                { type: "text" },
                { type: "number" },
                { type: "number" },
                { type: "text" },
                {type: "text" },
                {type: "text" },
                {type: "text" },
                null
            ]
            });

my problem is in the colum filter input i enter any thing keyup event trigger automatically. for example i type canada means sever side ajax ( GET ) load 6 times but i enter the input data ( canada ) not send to server side. how i solve this problem? we need to search filter in each column. enter each column filter data send to server with key. tell your suggestion.

jrizzi1

here is a server-side template, you should setup your case to have it diagnosed correctly
http://live.datatables.net/laxinabe/1/edit