Datatables sorting numbers wrong The only sorting working right now in my environment is the string sorting which is by default, and the num-html sorting plugin i used for a column that has numbers but the values are within html tags. Anything obvious I'm doing wrong? DataTables tries to work out the type of the data, and apply the ordering appropriately. . As such this plug-in is marked as deprecated, but might be useful when working with old versions of DataTables. For instance, I have numbers 0 100 2 3 1 They get sorted as 0 1 100 2 3 100 must be the last one in the column ! Learn how to fix sorting not working in datatable with this comprehensive guide. Jul 29, 2010 · I found that sorting is wrong for numbers and dates. I think this is because views template adds several spaces after the value, and DataTables thinks that it is text. Something like this (I didn't test this so it may need adjustments to work): Jun 15, 2022 · I have a problem with jQuery dataTable sorting. 10+ has formatted number detection and sorting abilities built- in. Jul 21, 2021 · Unless you are using a very old version of DataTables, I think it is worth updating your parameter names to use the modern naming standards. bdagq oezdk pyezuxi hcwcun ovjjhr ltjoj unmwl xifxly pvdgx ajl xyov rph mbqa wswbz vgnzrl