如何在jQuery DataTables中对数值列进行排序

Question

(看了一堆关于这个主题的答案，没有一个适用于这个问题。)

DataTables的功能是让用户点击每一列的向上/向下三角形图标，按升序或降序排序。我已经按如下方式加载了数据

        oTable.fnAddData( ["Bogus data","1,541,512","12.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","3,541,512","2.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","541,512","1.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","2,541,512","32.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","741,512","3.5%","0","0","0"]);
        oTable.fnAddData( ["A Bogus data","41,512","1.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","2,541,512","12.5%","0","0","0"]);
        oTable.fnAddData( ["Z Bogus data","1,541,512","12.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","3,541,512","2.5%","0","0","0"]);
        oTable.fnAddData( ["La Bogus data","541,512","1.5%","0","0","0"]);
        oTable.fnAddData( ["The Bogus data","2,541,512","32.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","741,512","3.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","41,512","1.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","2,541,512","12.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","1,541,512","12.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","3,541,512","2.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","541,512","1.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","2,541,512","32.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","741,512","3.5%","0","0","0"]);
        oTable.fnAddData( ["Bogus data","41,512","1.5%","0","0","0"]);

在第2列中，当我单击Up/Down三角形时，将按字母顺序处理数值。我如何调整它，使第二列向上/向下箭头以正确的方式触发，将字符视为数字。我尝试使用以下初始化：

oTable = $('.utable').dataTable( {
"aoColumns": [{ sWidth: '60%' },{sWidth: '30%', "sType": "numeric"},{ sWidth: '10%' }],
"sDom": 'rt',
"sScrollY":"200px",
"bPaginate":false,
"bFilter":false,
"bInfo": false});  

所有这些操作都是锁定列，并且Up/Down图标在该列的标题中将不起作用。

Answer 1

你的问题是这些数字没有被识别出来，即使它们被识别了，你的数字中的逗号可能会关闭排序功能(因为它可能不会正确地删除它们)。

你有一个选择是实现你自己的排序函数，它可以正确地处理你的数字。下面的示例可以满足您的需求：

http://live.datatables.net/oborug/2/edit

PS --下面是相关文档：http://datatables.net/development/sorting

Answer 2

从技术上讲，第2列包含字符串(1,000) -带逗号的数字，第3列也是如此-带百分比的数字)。最好的做法是将数据作为整数(不带逗号和%)传递到数据表，并编写一个自定义格式化程序来使用mRender选项添加逗号和百分比(在上阅读该选项)。

如果您还向数据添加自定义格式，请不要忘记设置选项以使用基础数据作为排序源，而不是显示的数据。

Answer 3

您必须定义一个排序函数(尝试使用按选择排序或按插入排序)尝试在数组中存储数据变量并进行计算，否则您可以直接对数据进行排序