Skip to main content

jQuery Datatable disable sorting for one column or multiple column

jQuery Datatable disable sorting for one column


Sometimes we want to remove sorting in datatable so today we will learn how to disable sorting for any specific column in simple steps.

jQuery datatable provides columnDefs option that we can use to remove sorting (asc/desc) from any column .


Please use below code:
 
var oTable= $('#idDataTable').DataTable({
              "order": [[ 3, "asc" ]],
              'columnDefs': [{
                    "targets": [0],
                    "orderable": false
                }]
          });


So in above code we mentioned targets as 0, that means it will disable ascending descending option for first column, you can disable sorting for multiple columns by separating them with comma(,)


Source code for disable sorting for multiple column.

var oTable= $('#idDataTable').DataTable({
              "order": [[ 3, "asc" ]],
              'columnDefs': [{
                    "targets": [0,1,2],
                    "orderable": false
                }]
          });

Thanks 
Labels:

Comments

  1. Unknown25 February 2020 at 11:52

    If you're trying to lose pounds then you absolutely need to jump on this brand new custom keto diet.

    To create this keto diet service, certified nutritionists, fitness trainers, and chefs joined together to develop keto meal plans that are useful, convenient, cost-efficient, and enjoyable.

    Since their launch in 2019, thousands of clients have already remodeled their body and health with the benefits a great keto diet can offer.

    Speaking of benefits; clicking this link, you'll discover eight scientifically-certified ones provided by the keto diet.

    ReplyDelete
  2. Unknown1 March 2020 at 12:00

    If you're trying hard to lose pounds then you certainly have to start following this brand new custom keto diet.

    To create this keto diet service, certified nutritionists, personal trainers, and professional chefs have united to provide keto meal plans that are powerful, painless, economically-efficient, and delicious.

    Since their grand opening in January 2019, 1000's of clients have already completely transformed their figure and well-being with the benefits a professional keto diet can offer.

    Speaking of benefits: clicking this link, you'll discover eight scientifically-tested ones offered by the keto diet.

    ReplyDelete
  3. Unknown14 February 2021 at 04:48

    şlö

    ReplyDelete
  4. محمد غالى25 December 2021 at 14:20

    شركة كشف تسربات المياه

    ReplyDelete

Post a Comment

Popular posts from this blog

Run and compile sass scss file to css using node

  Today we learn how to use scss and generate css using node  or Run and compile sass scss file to css using node   So please follow simple  steps :-   Today we will create a project that can read scss file and generates css with it  Note: Make sure you have installed node in your system. If you want to help to install node js based on your system then check our other tutorial or check node js official website. Now create a blank folder and open  terminal(linux) or cmd(windows) and navigate to your current project folder by using cd command Now run below command npm init after enter it will ask you some package info that you can fill according to you or just keep enter until it finished. The above command will generate package.json file Now  we will install npm module that will convert our scss to css Run below command: npm install node-sass So we have installed node-sass package . Now open package.json file in your editor and add below code into it into
12 comments
Read more

How to retrieve Facebook Likes, share , comment Counts

function facebook_count($url){     // Query in FQL     $fql  = "SELECT share_count, like_count, comment_count ";     $fql .= " FROM link_stat WHERE url = '$url'";     $fqlURL = "https://api.facebook.com/method/fql.query?format=json&query=" . urlencode($fql);     // Facebook Response is in JSON     $response = file_get_contents($fqlURL);     return json_decode($response); } $fb = facebook_count('https://www.facebook.com/BahutHoGyiPadhai'); // facebook share count echo $fb[0]->share_count;  echo "like"; // facebook like count echo $fb[0]->like_count ; echo "comment"; // facebook comment count echo $fb[0]->comment_count;  ?>
18 comments
Read more

jQuery Datatable add date range filter

jQuery Datatable add date range filter Datatable is most useful jQuery plugin that helps to make our html tables more powerful and give powers to user to filter , search, sort, pagination etc, But Data table provides a common filter only and yes we can customize and add filter for each column, but still sometimes we need an advance filter like show results only between a date range, So today we will learn how to create a minimum and maximum date range fields and show date picker on it, and user can fill dates by selecting dates and data table will auto filter records based on it. Keep follow below steps :- I am using Bootstrap if you want to use any other framework then you can use. Create a new index.php file  and paste below code in it, i have used all required CDN like bootstrap, datatable, datepicker etc. <!DOCTYPE html> <html> <head>     <title>Datatable Date Range Filter Example</title>     <link rel="stylesheet" href="https://maxcd
Post a Comment
Read more