Data Type seems to be detected from the data-order rather than the actual data

chufford

I have a row like this:
<tr>
<th>Information</th>
</tr>
<tr>
<td data-order="1699675200" class="dt-type-numeric sorting_1"><a href="page?id=123">Text</a>
</td>
</tr>.....
When the table is rendered it gets the 'dt-type-numeric sorting_1' class which makes it right-justified. Since it is visible text, I want it to be left-justified, even though the data to sort on is numeric.
The workaround I found is to simply add a letter to look like this: data-order="x1699675200", but that may mess up the sort. Is there a better way?

kthorngren

One option is to remove or change the class for the numeric type using DataTable.type(). This will affect all numeric columns.

Another option is to remove the class from specific columns using column().header() and column().nodes() in initComplete.

Kevin

allan

Another option is to add another class to the column (columns.className) and use that to force the text alignment as you need.

Multiple data types for a column is something I've considered before, but I'm concerned about the performance impact, and it is something that doesn't get used all that often. For the moment, a workaround such as suggested is the way to handle such a situation.

Allan