Datatables column filter checkbox not working with Ajax

Question

When bind datatables with ajax then I datatables column filter checkbox disappear. Here is my code

$('#Table1').dataTable({
    "ajaxSource": "js/Group.JSON"
}).columnFilter({
    sPlaceHolder: "head:after",
    aoColumns: [
         { type: "checkbox", values: null },
         { type: "checkbox", values: null },
         { type: "checkbox", values: null },
         { type: "checkbox", values: null },
         { type: "checkbox", values: null },
         { type: "checkbox", values: null }
    ]
});

jquery-datatables-column-filter.googlecode.com/svn/trunk/… here is the checkbox in filter — Naveed Iqbal
– Naveed Iqbal, Commented Jul 23, 2015 at 11:05

davidkonrad · Accepted Answer · 2015-07-23 11:52:29Z

2

Without knowing anything about what is going on - all we know is a comment about "it is not working when I get data from ajax" - and therefore assuming everything else is working great, no news is good news etc; and taken notice of ColumnFilter as being an old buggy plugin built for dataTables 1.9.x with +100 open issues, last fix was nearly 1½ year ago - then I would say this is a simple matter of javascript asynchronicity.

When using chaining

$('#Table1').dataTable({
    //some ajax stuff
}).columnFilter({ .. })

then columnFilter({ .. }) is executed immediately, it does not wait until AJAX has finished its business. The result is that there is no data loaded at the time of the columnFilter initialisation. To prevent this, initialise columnFilter in a callback :

$('#Table1').dataTable({
    fnInitComplete : function() {
        this.columnFilter({
           sPlaceHolder: "head:after",
           ...
        })      
    }
})

answered Jul 23, 2015 at 11:52

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Naveed Iqbal Over a year ago

Great!! it is working!! THank you so much davidkonrad :)

Naveed Iqbal Over a year ago

I have same issue with updatepanel(asp.net), I put datatable grid inside updatepanel, all are working fine, but when updatepanel called the checkbox column filter disappear, I applied your edited code but no luck

Naveed Iqbal Over a year ago

I asked above mentioned question on the following link stackoverflow.com/questions/31587656/…

Collectives™ on Stack Overflow

Datatables column filter checkbox not working with Ajax

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related