How sort with specific column in Datatables?

Question

I am using Datatables to print HTML tables,here i am stuck with something like:

table is dynamically created (printed with while loop) due to which I don't know how many columns will it have. After that I applied datatables on

$('#table').dataTable( {
            "bDestroy":true,        
            "sScrollY": temp_fh,             
            "bPaginate": false,
            "bScrollCollapse": true,
            "bProcessing": true,
            "bFilter":true,
            "bSort":true,
                  });

So now how do I apply sorting for only 2nd column?

Since I referred bSortable from Datatables which allows us to disable sorting for particular column but in this case we don't known how much columns will table have.

Thanks.

there is an option to select all columns. You can try with s.th like that: { "aTargets": [ '_all' ], "bSortable": false } — Markus Kösel
– Markus Kösel, Commented Nov 20, 2013 at 4:08
@MarkusKösel :that will remove sorting for all columns, i want sorting on only col1 and col2. — Ganesh
– Ganesh, Commented Nov 20, 2013 at 4:12

Community · Accepted Answer · 2017-05-23 11:55:11Z

7

how about this?

$('#table').dataTable( {
        "bDestroy":true,        
        "sScrollY": temp_fh,             
        "bPaginate": false,
        "bScrollCollapse": true,
        "bProcessing": true,
        "bFilter":true,
        "bSort":true,
        aoColumnDefs: [
           { aTargets: [ '_all' ], bSortable: false },
           { aTargets: [ 0 ], bSortable: true },
           { aTargets: [ 1 ], bSortable: true }
        ]

Update

ok, overriding _all seems not possible. maybe you can disable sorting on columns by css like this in your while-loop:

<th class="no-sort">

and use this initialization code:

// Disable sorting on the no-sort class
"aoColumnDefs" : [ {
"bSortable" : false,
"aTargets" : [ "no-sort" ]
} ]

see: disable a column sorting using jquery datatables

edited May 23, 2017 at 11:55

CommunityBot

11 silver badge

answered Nov 20, 2013 at 4:17

Markus Kösel

7531 gold badge6 silver badges17 bronze badges

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

2 Comments

Ganesh Over a year ago

no luck, i guess since we are using { aTargets: [ '_all' ], bSortable: false } it will disable sorting for all columns.

Markus Kösel Over a year ago

hm, i thought, that with the other two lines, column 1 and 2 should be enabled again. bSort should be enabled. I accidentaly commented it out in my example

Collectives™ on Stack Overflow

How sort with specific column in Datatables?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related