Answers

• kthorngren Posts: 20,274Questions: 26Answers: 4,765

  May 2019 edited May 2019

  You can include the selector-modifie of {order:'current'} as shown here:
  https://datatables.net/reference/type/selector-modifier#order

  EDIT: Assuming you have the table sorted by the date column you want.

  Kevin
• sumnone Posts: 4Questions: 1Answers: 0

  May 2019 edited May 2019

  Thanks for the reply. I'm not sure what you mean... I'm displaying totals in column 15... but want it ordered by date in column 9. {order:'current'} seems to be the default setting?

  I also just tried this:
  totalsArray = totalsArray.order([9, 'asc']);

  That sets the correct order on the chart like I want, but also highjacks the order of the table too. How can I separate these from each other?
• colin Posts: 15,142Questions: 1Answers: 2,586

  May 2019 edited May 2019

  Hi @sumnone ,

  You can't change the type - if it's recognised as a date field, that all the ordering will be in that format. The function you mentioned, sort(), works on the data, so you need

  var totalsArray = api.column(15, { page: 'current' }).data().sort();
  

  See here,

  Cheers,

  Colin
• sumnone Posts: 4Questions: 1Answers: 0

  May 2019

  Hi, thanks for the reply. Column 15 is a decimal (and will remain a decimal) that I am trying to sort by column 9 which is a date (and will remain a date). Therefore, I am trying to always sort column 15 in chronological order ascending, but on the chart only. I want all the sort column functions to remain working in my table, while the chart always orders everything in chronological order.

  Essentially, I'm calling the api.column() in my datatables footerCallback and piecing together my chart data there. But, any manipulation of the api data, equally affects the original table data too.

  I could make another call to the server and grab a second set of json data and break the chart data into it's own thing (outside the datatables function), but that's not optimal, although really easy.

  It's looking like it's not possible inherently in datatables without maybe cloning the datatables data array and then manipulating that second data array through pure javascript?

  I kind of gave up on it for the moment. If I ever figure out something clean, I'll post it back here. Thanks again for the replies.
• sumnone Posts: 4Questions: 1Answers: 0

  May 2019

  I was looking to solve another issue and ended up finding the solution to this one. I used the example code from the following link to split out the array:

  https://datatables.net/reference/api/ajax.json()

  Not only does it sort the chart by date always (it never moves, always looks exactly the same no matter how I sort datatables), but the whole thing just seems to perform better now too.