JQuery datatables sort on different source

Question

I'm using JQuery datatables plugin and works really well. Problem I have is sorting a date field. The date field is the first field in the table.

For a better UX (because day of the week is an important factor) I want to show dates in ascending order like this:

Fri 4th July 2014
Thu 10th July 2014
Fri 18th July 2014

When I load the table into datatables it sort the field thus:

Fri 18th July 2014
Fri 4th July 2014
Thu 10th July 2014

Which is alpha numeric. Not good for dates.

Is there any way I can add a field to the <td> e.g. <td data-sort="2014-05-06"> and have it sort according to that variable instead of just the cell contents for that particular column?

I have searched their docs and API but can't see an immediate solution.

see datatables.net/examples/advanced_init/html5-data-attributes.html use data-order=(date in timestamp format) — Tamil Selvan C
– Tamil Selvan C, Commented Jul 21, 2014 at 11:46
That's exactly it! Many thanks - if you want to add it as answer I'll accept — StudioTime
– StudioTime, Commented Jul 21, 2014 at 11:51

Tamil Selvan C · Accepted Answer · 2014-07-21 12:35:15Z

1

Use data-order=(date in timestamp format)

<td data-order="1332975600">Thu 29th Mar 12</td>

Refer: http://datatables.net/examples/advanced_init/html5-data-attributes.html

answered Jul 21, 2014 at 12:35

Tamil Selvan C

20.3k12 gold badges55 silver badges72 bronze badges

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

Comments

StudioTime · Accepted Answer · 2014-07-21 12:37:59Z

1

The answer is actually in my question... I guessed what the solution should be without trying it as I couldn't find any reference to it.

tl;dr

<td data-sort="2014-05-06">

Many thanks @TamilSelvan

You can also use timestamp as suggested below

edited Jul 21, 2014 at 12:37

answered Jul 21, 2014 at 12:12

StudioTime

24.4k40 gold badges129 silver badges217 bronze badges

Collectives™ on Stack Overflow

JQuery datatables sort on different source

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related