Exclude Row from sorting - Datatables.net

Question

I have a question about how to exclude a row(tr) from sorting. I want to make something like this http://jsfiddle.net/rishijagati/WwDg8/213/ but I don't want to set the data of the hidden row in jQuery. I suppose that you can do it adding a class to the <tr> element and after that manage to not sort this <tr> on initializing the datatable on jQuery. Actually I have the initialization like this:

$('.ordered_table').dataTable({
        "sPaginationType": "full_numbers",
        "dom": '<"toolbar">frtip',
        "pagingType": "numbers",
        "searching": false,
        "pageLength": 20,
        columnDefs: [{
          targets:  ['datatable-nosort'],
          orderable: false,  
          bsortable: false
        }],
        "aaSorting": []
 });

The class datatable-nosort is for not sorting on columns, this is not for rows.

Now is showing always this message, but I have made the accordion effect but the sorting is not working.

Uncaught TypeError: Cannot set property '_DT_CellIndex' of undefined

My table is like this:

<tr class="tr_tbody accordion">
   <td><%= order.id %></td>
   <td><%= order.created_at.strftime("%d/%m/%Y") %></td>
   <td><%= order.exhibitor_corporate_name %></td>
   <td><%= order.candidate_first_name %> <%= order.candidate_last_name %></td>
   <td><%= !order.engagements.first.nil? ? order.engagements.first.date.strftime("%d/%m/%Y") : ''   %></td>
   <td><%= !order.engagements.last.nil? ? order.engagements.last.date.strftime("%d/%m/%Y") : ''   %></td>
   <%
   number = @total_hours
   parts = number.to_s.split(".")
   result = parts.count > 1 ? parts[1].to_s : 0
   result = '0' + '.' + result.to_s
   hours = parts.count > 1 ? parts[0].to_s : 0
   %>
   <td class="datatable-nosort">
      <%= hours.to_s %>
      <%= 'h. ' %>
      <%= (result.to_f*60).to_i %>
      <%= 'm.' %> 
   </td>
   <td><%= @price_ngage %>€</td>
   <td></td>
</tr>
<tr >
   <td colspan="9">
   Order details
   </td>
</tr>

webster · Accepted Answer · 2020-02-21 11:37:17Z

9

This worked for me:

<table>
<thead>
...
</thead>
<tbody>
...
</tbody>
<tfoot>
    <tr class="no-sort">
        <td>...</td>
        <td>...</td>
    </tr>
</tfoot>
</table>

answered Feb 21, 2020 at 11:37

webster

4,0326 gold badges41 silver badges61 bronze badges

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

1 Comment

Paco Gómez Capón Over a year ago

Thank you @webster !! But this question is from 2016 so... :)

Gyrocode.com · Accepted Answer · 2016-11-11 19:53:54Z

0

From the documentation for columnDefs.targets option:

... class name will be matched on the TH for the column (without a leading .)

So you have to apply class datatable-nosort to the TH element in the header.

Another error occurs most likely because DataTables do not support colspan or rowspan in table body. To show extra details, use child row functionality instead.

answered Nov 11, 2016 at 19:53

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

1 Comment

lofihelsinki Over a year ago

Reading the title of the question might be useful: Exclude Row from sorting - Datatables.net

Collectives™ on Stack Overflow

Exclude Row from sorting - Datatables.net

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related