Disable sorting for a particular column in jQuery DataTables

Question

I am using the jQuery DataTables plugin to sort the table fields  My question is  how do I disable sorting for a particular column  I have tried with the following code  but it did not work    aoColumns          bSearchable   false      null        I have also tried the following code    aoColumnDefs              bSearchable   false       aTargets     1           but this still did not produce the desired results

User · Answer

set class  no-sort  in th of the table then add css   no-sort   pointer-events  none  important  cursor  default  important background-image  none  important    by this it will hide the arrow updown and disble event in the head

User · Answer

As of DataTables 1 10 5 it is now possible to define initialisation   options using HTML5 data-  attributes    -from DataTables example - HTML5 data-  attributes - table options  So you can use data-orderable  false  on the th of the column you don t want to be sortable  For example  the second column  Avatar  in the table below will not be sortable    lt table id  example  class  display  width  100   data-page-length  25  gt       lt thead gt           lt tr gt               lt th gt Name lt  th gt               lt th data-orderable  false  gt Avatar lt  th gt               lt th gt Start date lt  th gt               lt th gt Salary lt  th gt           lt  tr gt       lt  thead gt       lt tbody gt           lt tr gt               lt td gt Tiger Nixon lt  td gt               lt td gt  lt img src  https   www gravatar com avatar 8edcff60cdcca2ad650758fa524d4990 s 64 amp amp d identicon amp amp r PG  alt    style  width  64px  height  64px  visibility  visible   gt  lt  td gt               lt td gt 2011 04 25 lt  td gt               lt td gt  320 800 lt  td gt           lt  tr gt           lt tr gt               lt td gt Garrett Winters lt  td gt               lt td gt  lt img src  https   www gravatar com avatar 98fe9834dcca2ad650758fa524d4990 s 64 amp amp d identicon amp amp r PG  alt    style  width  64px  height  64px  visibility  visible   gt  lt  td gt               lt td gt 2011 07 25 lt  td gt               lt td gt  170 750 lt  td gt           lt  tr gt              ETC          lt  tbody gt   lt  table gt    See a working example at https   jsfiddle net jhfrench 6yxvxt7L

User · Answer

This works for me for a single column       example   dataTable     aoColumns        bSortable   false

User · Answer

What I use is just add a custom attribute in thead td and control sorting by checking that attr value automatically   So the HTML code will be   lt table class  datatables  cellspacing  0px   gt        lt thead gt           lt tr gt               lt td data-bSortable  true  gt Requirements lt  td gt               lt td gt Test Cases lt  td gt               lt td data-bSortable  true  gt Automated lt  td gt               lt td gt Created On lt  td gt               lt td gt Automated Status lt  td gt               lt td gt Tags lt  td gt               lt td gt Action lt  td gt           lt  tr gt       lt  thead gt       lt tbody gt           lt tr gt               lt td gt    And JavaScript for initializing datatables will be  it will dynamically get the sorting information from table iteself         datatables   each function        var bFilter   true      if   this  hasClass  nofilter             bFilter   false            var columnSort   new Array         this  find  thead tr td   each function            if   this  attr  data-bSortable       true                 columnSort push    bSortable   true               else               columnSort push    bSortable   false                             this  dataTable            sPaginationType    full numbers            bFilter   bFilter           fnDrawCallback   function  oSettings                         aoColumns   columnSort

User · Answer

you can also use negative index like this       datatable   dataTable        sDom     lt  row-fluid  lt  span6 l gt  lt  span6 f gt r gt t lt  row-fluid  lt  span6 i gt  lt  span6 p gt  gt         sPaginationType    bootstrap        aoColumnDefs                bSortable   false   aTargets     -1

User · Answer

To make a first column sorting disable  try with the below code in datatables jquery  The null represents the sorting enable here       example   dataTable       aoColumns          bSortable   false      null    null    null            Disable Sorting on a Column in jQuery Datatables

User · Answer

If you already have to hide Some columns  like I hide last name column  I just had to concatenate fname   lname   So i made query but hide that column from front end  The modifications in Disable sorting in such situation are          aoColumnDefs                bSortable   false   aTargets     3                             targets     4                 visible   false               searchable   true                    Notice that I had Hiding functionality here       columnDefs                                    targets     4                     visible   false                   searchable   true                            Then I merged it into  aoColumnDefs

User · Answer

As of 1 10 5  simply include      orderable  false    in columnDefs and target your column with       targets   0 1     Table should like like    var table       data-tables   DataTable       columnDefs             targets   0           orderable  false

User · Answer

There are two ways  one is defined in html when you define table headers   lt thead gt     lt th data-orderable  false  gt  lt  th gt   lt  thead gt    Another way is using javascript  for example  you have table   lt table id  datatables  gt       lt thead gt           lt tr gt               lt th class  testid input  gt test id lt  th gt               lt th class  testname input  gt test name lt  th gt       lt  thead gt   lt  table gt    then     document  ready function             datatables   DataTable             columnDefs                    targets     0      0 indicates the first column you define in  lt thead gt               searchable   false                                      you can also use name to get the target column              targets    testid      name is the class you define in  lt th gt               searchable   false

User · Answer

Here is what you can use to disable certain column to be disabled        tableId   dataTable                           columns                        data    id                       data    sampleSortableColumn                        data    otherSortableColumn                        data    unsortableColumn    orderable   false                     So all you have to do is add the  orderable   false to the column you don t want to be sortable

User · Answer

Using class    lt table  class  table table-datatable table-bordered  id  tableID  gt       lt thead gt           lt tr gt               lt th class  nosort  gt  lt input type  checkbox  id  checkAllreInvitation    gt  lt  th gt               lt th class  sort-alpha  gt Employee name lt  th gt               lt th class  sort-alpha  gt Send Date lt  th gt               lt th class  sort-alpha  gt Sender lt  th gt           lt  tr gt       lt  thead gt       lt tbody gt           lt tr gt               lt td gt  lt input type  checkbox  name  userUid    value   user uid   id  checkAllreInvitation  class  checkItemre validate required     gt  lt  td gt               lt td gt Alexander Schwartz lt  td gt               lt td gt 27 12 2015 lt  td gt               lt td gt dummy email com lt  td gt           lt  tr gt       lt  tbody gt   lt  table gt   lt script type  text javascript  gt        document  ready function                 tableID   DataTable                iDisplayLength  100               aaSorting      0   asc                   aoColumnDefs                       bSortable   false                   aTargets     nosort                                       lt  script gt       Now you can give  nosort  class to  lt TH gt

User · Answer

example   dataTable           aoColumnDefs             bSortable   false          aTargets    0  1  2  3  4  5

User · Answer

This is what you re looking for           example   dataTable           aoColumnDefs                  bSortable   false   aTargets     1

User · Answer

aoColumnDefs              bSortable    false       aTargets      0        Here 0 is the index of the column  if you want multiple columns to be not sorted  mention column index values seperated by comma

User · Answer

Here is the answer    targets is the column number  it starts from 0      example   dataTable       columnDefs            orderable   false   targets   0

User · Answer

columnDefs now accepts a class  I d say this is the preferred method if you d like to specify columns to disable in your markup    lt table gt       lt thead gt           lt tr gt               lt th gt ID lt  th gt               lt th gt Name lt  th gt               lt th class  datatable-nosort  gt Actions lt  th gt           lt  tr gt       lt  thead gt           lt  table gt    Then  in your JS      table   DataTable       columnDefs             targets   datatable-nosort           orderable  false

User · Answer

To update Bhavish s answer  which I think is for an older version of DataTables and didn t work for me    I think they changed the attribute name   Try this      lt thead gt       lt tr gt           lt td data-sortable  false  gt Requirements lt  td gt           lt td data-sortable  false  gt Automated lt  td gt           lt td gt Created On lt  td gt       lt  tr gt   lt  thead gt   lt tbody gt       lt tr gt           lt td gt

User · Answer

The code will look like this       data-cash   each function  index        this  dataTable        sDom     lt  row-fluid  lt  span6 l gt  lt  span6 f gt r gt t lt  row-fluid  lt  span6 i gt  lt  span6 p gt  gt         sPaginationType    bootstrap        oLanguage            sLengthMenu     MENU  records per page          oPaginate              sPrevious    Prev            sNext    Next                      bSort   false       aaSorting

User · Answer

Use the following code to disable ordering on first column       example   dataTable       columnDefs            orderable   false   targets   0             To disable default ordering  you can also use       example   dataTable          ordering   false

User · Answer

If you set the FIRST column orderable property to false  you must also set the default order column otherwise it won t work since first column is the default ordering column  Example below disables sorting on first column but sets second column as default order column  remember dataTables  indexes are zero based        example   dataTable       order     1   asc        columnDefs            orderable   false   targets   0

User · Answer

For Single column sorting disable try this example     lt script type  text javascript  gt                                 document  ready function                      example   dataTable               aoColumnDefs                      bSortable   false   aTargets     0                                                                                lt  script gt    For Multiple columns try this example  you just need to add column number  By default it s starting from 0   lt script type  text javascript  gt                                 document  ready function                      example   dataTable               aoColumnDefs                      bSortable   false   aTargets     0 1 2 4 5 6                                                                               lt  script gt      Here only Column 3 works

User · Answer

Using Datatables 1 9 4 I ve disabled the sorting for the first column with this code      Table initialisation      document  ready function             rules   dataTable            sDom      lt  row  lt  span6 l gt  lt  span6 f gt r gt t lt  row  lt  span6 i gt  lt  span6 p gt  gt             sPaginationType     bootstrap            oLanguage                   sLengthMenu      MENU  records per page                        Disable sorting on the first column          aoColumnDefs                     bSortable    false               aTargets      0                             EDIT   You can disable even by using the no-sort class on your  lt th gt     and use this initialization code      Disable sorting on the no-sort class  aoColumnDefs             bSortable    false       aTargets       no-sort          EDIT 2  In this example I m using Datables with Bootstrap  following an old blog post  Now there is one link with updated material about styling Datatables with bootstrap

User · Answer

You can directry use  notsortable   method on column    vm dtOpt product   DTOptionsBuilder newOptions                    withOption  responsive   true          vm dtOpt product withPaginationType  full numbers            vm dtOpt product withColumnFilter               aoColumns                         type   null                                           type   text                       bRegex  true                      bSmart  true                                          type   text                       bRegex  true                      bSmart  true                                          type   text                       bRegex  true                      bSmart  true                                          type   select                       bRegex  false                      bSmart  true                      values  vm dtProductTypes                                          vm dtColDefs product                 DTColumnDefBuilder newColumnDef 0   DTColumnDefBuilder newColumnDef 1               DTColumnDefBuilder newColumnDef 2   DTColumnDefBuilder newColumnDef 3  withClass  none                DTColumnDefBuilder newColumnDef 4   DTColumnDefBuilder newColumnDef 5  notSortable

[javascript] Disable sorting for a particular column in jQuery DataTables

Examples related to javascript

Examples related to jquery

Examples related to sorting

Examples related to datatables