sorting DataTables with setting false option on ordering

Question

Is it possible setting default sorting table by second column with disable change sorting?

I try in this way but on header of second column an arrow is visible. I want remove all arrow with the default sorting.

var table = data.DataTable({
    "pageLength": 5,
    "lengthChange": false,
    "info" : false,
    "responsive": true,
    "ordering": true,
    "order": [ 1, "asc" ],
    "columnDefs": [{
    "targets": "_all", "orderable": false
    }],
    "data": result,
    "columns": [
        { "data": null },
        { "data": "Class" },
        { "data": "count" },
        { "data": "group" }
        ]
});

table.on('order.dt', function () {
    table.column(0, { search: 'applied', order: 'applied' }).nodes()
    .each(function (cell, i) {
          cell.innerHTML = i + 1;
    });
}).draw();

Could you please provide more of your code. Kinda hard to know where this code fits in without having good knowledge and fresh experience with Jquery DataTables. That way you will reach more developers willing to take a look. — Avec
– Avec, Commented Mar 6, 2020 at 22:31

andrewJames · Accepted Answer · 2020-03-06 21:19:53Z

1

You can use this jQuery command to remove the grey triangle (background image) from the element:

$("th.sorting_desc").css('background-image', 'none');

This needs to be placed at the end of the "document ready" section (assuming that is what you are doing).

The only thing I would add is this: The triangle is there for a reason - to tell users how the data is sorted. I'd be reluctant to remove it myself (just my opinion).

(Your "targets": "_all", "orderable": false has taken care of the sorting question already. The table is not sortable by the user, once it has been displayed.)

Update

You may also want to stop the cursor from changing, when you roll over the table heading (for consistency of UI experience):

$("th.sorting_desc").css('cursor', 'default');

(Tested only in Firefox and Chrome.)

edited Mar 6, 2020 at 21:19

answered Mar 6, 2020 at 20:52

andrewJames

22.6k11 gold badges32 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

sorting DataTables with setting false option on ordering

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related