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

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

chuffordchufford Posts: 3Questions: 2Answers: 0

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?

Answers

  • kthorngrenkthorngren Posts: 22,158Questions: 26Answers: 5,100

    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

  • allanallan Posts: 64,743Questions: 1Answers: 10,712 Site admin

    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

Sign In or Register to comment.