jQuery Datatable sort by column header

Question

Basically, jQuery Datatable allow us to sort data by column index.

"order": [1, 'desc']

I wonder if we can sort by column header name? For example:

"order": ['my_column_name', 'desc']

Thankyou Alex

No. First hit in google... And what is the "header name"? Is it the text() content, is it a name="name" attribute or something else...? You could simply map your header names into integer constants, and use those constants instead of indexes. But what should be the benefit of doing that? A column index is basically just another name for the column anyway. 1 is the unique name for the second column... — davidkonrad
– davidkonrad, Commented Apr 17, 2017 at 4:12
There is always a tweak, like this -> jsfiddle.net/257jmovv but still cannot see the purpose, and it would only work more or less hardcoded on DOM tables anyway. — davidkonrad
– davidkonrad, Commented Apr 17, 2017 at 10:58

mmushtaq · Accepted Answer · 2017-04-17 05:57:41Z

6

Is there a way to use the name, data or class of the column in order to set the default column sort? No - not at this time.

Although this thread is posted in June-2015 but still I couldn't find such functionality in latest version of DataTable.

As a side note! You have to provide column index while ordering data of DataTable but you can get Column Name on which ordering is applied.

var order = table.order();
var columnIndex = order[0][0]; //column index
var orderDirection =order[0][1]; // asc or desc

//Get column header text;
var title = table.column(order[0][0]).header();
var columnName = $(title).html(); //Column Name

Demo

answered Apr 17, 2017 at 5:57

mmushtaq

3,5307 gold badges34 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shinto Joseph · Accepted Answer · 2020-05-20 08:09:33Z

6

First find the column index by jquery,

Then insert the column index in datatable function.

var sort_col = $('#table').find("th:contains('your column name')")[0].cellIndex;

$('#table').dataTable({             
    order: [[ sort_col, 'desc' ]]                
  });

This worked for me. Hope this helps. Thanks

answered May 20, 2020 at 8:09

Shinto Joseph

3,17131 silver badges25 bronze badges

Comments

Gijsbert · Accepted Answer · 2019-09-13 13:43:45Z

1

I found a solution to fix this problem

var column1 = table.parents('table').find("th:contains('Your th text')")[0].cellIndex; 
var column2 = table.parents('table').find("th:contains('Your th text')")[0].cellIndex;
table.parents('table').dataTable({
  order: [[column1, 'asc'], [column2, 'asc']]
});

answered Sep 13, 2019 at 13:43

Gijsbert

112 bronze badges

Collectives™ on Stack Overflow

jQuery Datatable sort by column header

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related