Disable Sorting On Specific Columns In Datatable

Websolutionstuff | Aug-24-2020 | Categories : jQuery

In this article, we will delve into the process of disabling sorting for specific columns in Datatables. If you find the need to eliminate sorting arrows or prevent sorting on particular columns, or even across all columns in Datatables, you can achieve this through the use of the columnDefs feature in jQuery.

With columnDefs, you can remove sorting arrows for one or more columns in your Datatable using jQuery. This gives you the flexibility to disable sorting and ordering for columns as per your project's specific requirements.

While Datatables offers a rich set of features, including sorting, pagination, search, and column ordering, there are instances where certain features may not align with the client's project needs. If you need to disable ordering, search, or visibility for specific columns, columnDefs provides the means to configure these options tailored to individual columns in your Datatable.

$(document).ready(function()
{
   $('#details').DataTable({
     'processing': true,
     'serverSide': true,
     'serverMethod': 'POST',
     'ajax': {
       'url':'/demo/details.php'
     },
     'columns': [
        { data: 'id' }, /* index - 0 */
        { data: 'name' }, /* index - 1 */
        { data: 'email' }, /* index - 2 */
        { data: 'phone_no' }, /* index - 3 */
        { data: 'country' } /* index - 4 */
     ],
     'columnDefs': [ {
        'targets': [3,4], /* column index */
        'orderable': false, /* true or false */
     }]
   });
});


 

Conclusion:

In conclusion, we have explored the effective method of disabling sorting for specific columns in Datatables. By leveraging the columnDefs feature in jQuery, we can easily remove sorting arrows, prevent sorting on particular columns, or even disable sorting across all columns within our Datatables.

 


You might also like:

Recommended Post
Featured Post
Laravel 9 Multiple Where Condition Query Example
Laravel 9 Multiple Where Condi...

In this article, we will see the laravel 9 and laravel 10 multiple where condition query example. We will learn&nbs...

Read More

Sep-30-2022

Multiple Row Grouping Datatables jQuery
Multiple Row Grouping Datatabl...

In this article, we will see how to row group in datatable in jquery. Datatables doesn't have row grouping buil...

Read More

Jun-04-2022

Laravel 6/7 CRUD tutorial with example
Laravel 6/7 CRUD tutorial with...

In this example, I will show you how to make simple laravel CRUD(insert, update, delete, or list) operations with e...

Read More

May-08-2020

How To Disable Future Date In jQuery Datepicker
How To Disable Future Date In...

In this tutorial, we will see how to disable future dates in jquery datepicker. In the date picker, today's dat...

Read More

Jun-17-2022