jQuery Datatable column inline edit

Here is a amazing library for column inline edit. Super easy to use. It saved so many hours of my life 🙂

https://github.com/ejbeaty/CellEdit

Advertisements

jQuery datatable add input to toolbar section

//This example will add a button in datatable toolbar. You can add any html element. You can find code here.

jquery Datatable table.columns is not a function

in my case, I replaced this
table.columns().search().draw();
with
table.api().columns().search().draw();

added .api() and it solved my problem.

jQuery Datatable fix header

need to add these two files

http://cdn.datatables.net/fixedheader/2.1.1/css/dataTables.fixedHeader.css
http://cdn.datatables.net/fixedheader/2.1.1/js/dataTables.fixedHeader.min.js

and this

var table = jQuery('#datatable').dataTable({});
new $.fn.dataTable.FixedHeader( table, {
    // alwaysCloneTop: true
    // "zTop": "2001"
    "offsetTop": 50
});

You can check more options here.

jQuery datatable multiple column sort

"aaSorting": [ [2,'asc'], [0,'desc'] ],

jQuery Datatable change column orders

Datatable API provides easiest way to do it.

"sDom": 'Rlfrtip',
"oColReorder": {
    "aiOrder": [8,7,2,3,4,5,6,0,1]
},

You can add any column order you want.