Datatables fnSort advise
问题描述:
寻找一些帮助,以便将fnSort放置在这个数据表代码中,使默认排序第二列,而不是第一列。我有:Datatables fnSort advise
dataClones['keyword_table_<?php echo ceil($countCallsCounter/7); ?>']=document.getElementById('keyword_table_<?php echo ceil($countCallsCounter/7); ?>').cloneNode(true);
$('#keyword_table_<?php echo ceil($countCallsCounter/7); ?>').dataTable({
//"sDom": "<'row'<'span6'l><'span6'f>r>t<'row'<'span6'i><'span6'p>>",
"sDom":"<<'span6'l><'span6'f>r>t<<'span6'i><'span6'p>>",
"sPaginationType": "bootstrap",
"oLanguage": {
"sLengthMenu": "_MENU_ records per page"
}
}
);
我知道我需要添加http://datatables.net/api#fnSort但我不是太熟悉JS这样一些快速的帮助如果可能的话后。
感谢
答
所有你需要做的是设置一个变量=为$(选择).datatable()调用。然后你可以调用variable.fnSort()。
var oTable; // Make sure this is within scope of your function, or where you want to execute the sort.
dataClones['keyword_table_<?php echo ceil($countCallsCounter/7); ?>']=document.getElementById('keyword_table_<?php echo ceil($countCallsCounter/7); ?>').cloneNode(true);
oTable = $('#keyword_table_<?php echo ceil($countCallsCounter/7); ?>').dataTable({
//"sDom": "<'row'<'span6'l><'span6'f>r>t<'row'<'span6'i><'span6'p>>",
"sDom":"<<'span6'l><'span6'f>r>t<<'span6'i><'span6'p>>",
"sPaginationType": "bootstrap",
"oLanguage": {
"sLengthMenu": "_MENU_ records per page"
}
}
);
function onSort(){
oTable.fnSort([0,'asc']);
}
此外,如果你知道列要对数据表你可以的初始化排序:
$('#example').dataTable({
"aaSorting": [[ 4, "desc" ]]
});
http://datatables.net/api#fnSort http://datatables.net/release-datatables/examples/basic_init/table_sorting.html