Cant Get The Numeric Sort Working Datatables Forums If datatables doesn't auto detect it, then it won't be able to sort it, even if you force it to use numeric type. since there is something else happening here and as noted in the forum rules, please post a link to a running test case showing the issue so we can offer some help. The render function is ran for various purposes and the 2 key ones for this purpose are "type" to determine what data type the column contains and "sort" to sort the column.
Numeric Sorting With Html Not Working Datatables Forums Datatables are a powerful tool for displaying and sorting data. however, it can be frustrating when your datatables are not sorting properly. this article will walk you through the steps to troubleshoot and fix sorting issues in datatables. I can see that what i need to do is add a data sort attribute to each table cell. i've tried adding this with the createdrow method, but although i can see the attribute in the html, it's not sorting numerically. When i sort on columns 'discounts' i get following result: i'm running out of ideas, what am i doing wrong? you've got serverside enabled, so the sorting is being done on the server, not the client the client just displays whatever is returned. I have a table with numbers ranging from 0 to 10,000 and the numeric sorting is failing. sorting in descending order results in: 980, 9600, 960, 93, 890 etc.
Sorting With Special Character And Alpha Numeric Value Not Working When i sort on columns 'discounts' i get following result: i'm running out of ideas, what am i doing wrong? you've got serverside enabled, so the sorting is being done on the server, not the client the client just displays whatever is returned. I have a table with numbers ranging from 0 to 10,000 and the numeric sorting is failing. sorting in descending order results in: 980, 9600, 960, 93, 890 etc. The problem you are running into is that the information in that column isn't simply a number, but your also for html data in there hence datatables is sorting it as a string. I am trying to sort this table values by correct order but no matter which option i take it does not work correctly. i tried each option here:. Sorting on the other columns appears to work fine, so i'm thinking it's the other data in that cell that's causing the issue. is there an option set of options i can use to fix this sort, or do i need to create a custom sort function and if so, how do i go about that?. I am using the latest revision of datatables and i am facing a trouble sorting numbers. 100 must be the last one in the column ! this question has an accepted answers jump to answer. you can define the column type. which column is it in your table specifically that is causing the issue?.
Comments are closed.