Datatable Remove Sorting from Specific Column Example

By Hardik Savani November 5, 2023 Category : jQuery

If you want to remove sorting arrows or disable sorting on specific columns in datatables library than you can do it using columnDefs. we can simple disable ordering arrows from table in data tables js. even you are using with php, laravel, codeigniter, vue js etc. we can disable particular column sorting like one column, first column, last column, specific index.

Datatable library makes very simple pagination, sorting and searching. Datatables by default provide all function by default like ordering, pagination, listing searching for all table column. But if you want to disable ordering, search or visibility for specific column then you can use columnDefs.

columnDefs provide to set parameter allows you to assign specific options to columns in data tables.

You can see sample code of columnDefs:

'columnDefs': [ {

'targets': [1,3], /* column index */

'orderable': false, /* true or false */

}]

Example:

$(document).ready(function(){

$('#empTable').DataTable({

'processing': true,

'serverSide': true,

'serverMethod': 'POST',

'ajax': {

'url':'/ajax/users.php'

},

'columns': [

{ data: 'id' }, /* index = 0 */

{ data: 'name' }, /* index = 1 */

{ data: 'email' }, /* index = 2 */

{ data: 'gender' }, /* index = 3 */

{ data: 'city' } /* index = 4 */

],

'columnDefs': [ {

'targets': [1,2], /* column index */

'orderable': false, /* true or false */

}]

});

});

I hope it can help you...

Shares