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 Socialite Login with Google Account
Laravel 9 Socialite Login with...

In this article, we will see laravel 9 socialite login with a google account. This post gives you an example of a larave...

Read More

Apr-15-2022

How to Create Zip File in Ubuntu using Command
How to Create Zip File in Ubun...

Hey folks! If you're anything like me, sometimes you just want a quick and straightforward way to bundle up a bunch...

Read More

Jan-24-2024

How To Get Last 7 Days Record In Laravel 8
How To Get Last 7 Days Record...

In this example, we will see how to get the last 7 days record in laravel 8. You can simply get the last 7 days record u...

Read More

Jan-31-2022

Laravel 8 QR Code Generator Example
Laravel 8 QR Code Generator Ex...

In this tutorial, we will see the laravel 8 QR code generator example. we will generate QR code using simpleso...

Read More

Jan-24-2022