Replies

• chuck Posts: 5Questions: 0Answers: 0

  March 2011

  Anyone have any ideas on this?
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  March 2011

  Hi chuck,
  
  What I think would be needed here is a custom sorting function which will be able to pick out the string that you want from your markup (depending on whatever trigger you want to swap between the two). There is some documentation on sorting functions here: http://datatables.net/development/sorting . Already created samples are here: http://datatables.net/plug-ins/sorting .
  
  There is actually another option for this - might might or might not work for you. You could have two hidden columns with the individual data and then sort on the hidden column based on the switching trigger. DataTables can have one column sorted by the data in another column using the iDataSort property: http://datatables.net/usage/columns#iDataSort . This would need to be changed at run time in the settings object, but I can show you how to do that if this sounds suitable.
  
  Allan
• chuck Posts: 5Questions: 0Answers: 0

  March 2011

  Hi Allen,
  
  thanks for you reply :)
  
  I think that the second option sounds good I understand how to complete it for the most part with the exception of how to use the column header to switch between sorting modes?
  
  Thanks for your help !!
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  March 2011

  Hi chuck,
  
  It is actually reasonably straight forward to change the data sort property of a column - you just need to do:
  
  [code]
  oSettings.aoColumns[ i ].iDataSort = z;
  [/code]
  where oSettings is the DataTables settings object (from fnSettings()), i is the column index that you want to change the data sort property for, and z is the column index you want to use for the sorting. Once you've changed the property just simply call fnDraw and the table will be reordered.
  
  Allan