Using DataTables I want to change the value of the data before rendering the table. I used this:
"fnRowCallback": function( nRow, aData, iDisplayIndex ) {
if ( aData[2] == "0" ){
$('td:eq(1)', nRow).html( '<b>6</b>' );
}
}
But I found that although I changed the displayed text to be 0 to 6, when I sort by the column it's still sorting by the data and not the displayed text.
Does anyone know how I can actually change the data in the cell so that when I sort it will correctly sort by 0-6?