Filter based on column

saravananmca

The following code i had used for calling my method to render the data,
I have more than 10 field. I need to make more than two or there drop down for filter the records.
When ever i changes the drop downlist the filter should be happen. I am newer to use datatable. Your suggestion
would be highly valuable to us.

var table;

$(function () {

table = $('#tblAbondmentDetailist').DataTable({
    serverSide: true,
    processing: true,
    ordering: false,
    pagingType: "full_numbers",
    pageLength: 5,
    ajax: {
        url: "/AbondmentDetail/GetAbondmentList/",
        type: "GET"
    },
    columns: [
        { "data": "CustomerEmailId", "orderable": false },
        { "data": "OrderType", "orderable": false }
    ]
});

});

Customer Email	Order Type

Regards,
Saravanan

daniel_r

First you must "Master" loading datatables from server including sorting/pagination, then you should make the global search work (the search bar in the upper right corner)

Then you can take a look on my yadcf plugin for datatables, here is the relevant showcase page http://yadcf-showcase.appspot.com/server_side_source.html , see code samples on that showcase page and read docs

good luck.

saravananmca

Thank you Daniel, let me check with this page http://yadcf-showcase.appspot.com/server_side_source.html