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 Has Many Through Relationship Example
Laravel 9 Has Many Through Rel...

In this article, we will see that laravel 9 has many through relationship example. hasManyThrough relationship is diffic...

Read More

Apr-04-2022

How to File Upload in Angular 17 Tutorial
How to File Upload in Angular...

In this article, we'll see how to file upload in the angular 17 tutorial. Here, we'll learn about file uplo...

Read More

Apr-03-2024

How To Validate URL In PHP With Regex
How To Validate URL In PHP Wit...

Hello Guys, In this tutorial we will see how to validate URL in PHP with regex. also you can implement in larave...

Read More

Apr-13-2021

How To Install phpMyAdmin In Ubuntu
How To Install phpMyAdmin In U...

In this article, we will explore the process of installing phpMyAdmin in Ubuntu. phpMyAdmin is a popular web-based admin...

Read More

Jul-24-2023