Answers

• allan Posts: 63,538Questions: 1Answers: 10,476 Site admin

  April 15

  Two options:

  1. Apply it using columnDefs with the _all target.
  2. Set the default with DataTable.defaults.column.orderSequence.

  It would have been better to have to enable the 3 state and default to 2 state ('asc', 'desc') as that is the original default behaviour.

  v2 was the time to introduce a few changes to the defaults. deferRender has also been abled by default now. The list of changes is available here, although I see I missed the orderSequence part. Apologies - I'll fix that.

  Allan
• allan Posts: 63,538Questions: 1Answers: 10,476 Site admin

  April 15

  I've just committed the following which will be included on the site when I next deploy it (tomorrow):

  Order sequence

  When ordering columns by clicking on their header element, in v1 it would simply toggle between ascending and descending ordering for the columns (controllable with the columns.orderSequence option). DataTables 2 introduces a new option to this parameter, an empty string value which represents no ordering. The default has been updated to make use of this and the ordering sequence that is applied when clicking the header cell is now:

  • Ascending
  • Descending
  • No order

  It will repeat that sequence indefinitely as the column header is clicked. As before, it can be controlled using the columns.orderSequence option, and if you wish to restore the default DataTables 1.x behaviour you can do so by setting the default:

  DataTable.defaults.column.orderSequence = ['asc', 'desc'];
  

  Allan
• brianjaikens-msl Posts: 6Questions: 2Answers: 0

  April 16

  This is wonderful Allan. Thank you for the clarification and the speed of reply.
• xtremevision Posts: 4Questions: 2Answers: 1

  May 26

  Excellent! Just what was needed. Thank you.