jQuery DataTables plugin - secondary sorting (multiple column)

Question

I can't find a solution for this in DataTables plugin. What I want is to have secondary sorting. What I mean by that is - for example, I have a table with product name and price, something like this:

    NAME               PRICE
    A product          22.00 $
    C product          50.00 $
    B product          50.00 $
    D product          50.00 $
    E product          26.00 $
    F product          12.00 $

When the user clicks on PRICE this happens:

    NAME               PRICE
    F product          12.00 $
    A product          22.00 $
    E product          26.00 $
    C product          50.00 $
    B product          50.00 $
    D product          50.00 $

But I need this to happen:

    NAME               PRICE
    F product          12.00 $
    A product          22.00 $
    E product          26.00 $
    B product          50.00 $
    C product          50.00 $
    D product          50.00 $

    (note the last three products - they are sorted a-z)

Or basically, I need what's described here.

Thanks in advance if you have any ideas!

Manie · Accepted Answer · 2010-08-09 06:25:54Z

1

Try this:

 oTable.fnSort( [ [0,'asc'], [1,'asc'] ] );

answered Aug 9, 2010 at 6:25

Manie

2,0382 gold badges16 silver badges19 bronze badges

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

1 Comment

Manie Over a year ago

It will sort immediately with columns 0 and 1.

Stefan T · Accepted Answer · 2010-08-28 18:02:05Z

0

Sorry, forgot to answer here. I've found a solution - use the aaSort function but you need to patch it in the script. Change line 4085 to:

aaSort = oSettings.aaSorting.concat( oSettings.aaSortingFixed );

answered Aug 28, 2010 at 18:02

Stefan T

1253 silver badges13 bronze badges

2 Comments

Raje Over a year ago

Hi, Could you post your answer. I need same thing.

Stefan T Over a year ago

It was more than two years ago, but I think the answer is right there: use the aaSort function, but patch your script beforehand.

Collectives™ on Stack Overflow

jQuery DataTables plugin - secondary sorting (multiple column)

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related