DataTables
Advanced interaction
features for your tables.
Editor
Comprehensive editing
library for DataTables.
Manual
Download
≡ Show site navigation

How to sort on two columns

How to sort on two columns

arcaninearcanine Posts: 16Questions: 0Answers: 0
edited February 2013 in General
Hi,
I've got two date columns, how can I make it so that when you click a column it sorts by two date columns behind the scenes?

Replies

  • allanallan Posts: 63,523Questions: 1Answers: 10,473 Site admin
    edited February 2013
    Use aDataSort .

    Allan
  • arcaninearcanine Posts: 16Questions: 0Answers: 0
    thank you allan, how can I control asc and desc for each individual column in a multi sort column?
  • allanallan Posts: 63,523Questions: 1Answers: 10,473 Site admin
    Currently you cannot - they will both be the same. Sensible prospect for a future enhancement though.

    Allan
  • arcaninearcanine Posts: 16Questions: 0Answers: 0
    edited February 2013
    Oh I see, is it possible to have the initial click for the multiple column sort to be different? It seems to be ASC at the moment I'd like to have it at least so that the the two columns will sort by DESC on first click.

    edit: "aasorting" will do this http://datatables.net/docs/DataTables/1.9.beta.1/DataTable.defaults.columns.html#asSorting_details
This discussion has been closed.

DataTables

DataTables designed and created by SpryMedia Ltd.
© 2007-2023 MIT licensed. Privacy policy. Supporters.
SpryMedia Ltd is registered in Scotland, company no. SC456502.