datatables隐藏列排序
var tableOption = { id: 'cacScriptTable', order: [[2, 'desc'],[1, 'desc']],//以第三列‘updatedAt’排序,如果第三列的值相同就以第二列排序 aoColumns: [ {mData: 'scriptName', title: '名称'}, {mData: 'endedAt', title: '创建时间', visible: false,order:'desc'}, {mData: 'updatedAt', title: '修改时间', visible: false,order:'desc'}, {mData: 'scriptName', title: '名称'}, {mData: 'scriptParams', title: '参数'}, {mData: 'createdBy', title: '上传用户'}, {mData: 'description', title: '描述'}, { mData: 'id', title: '操作', className: 'text-center', searchable: false, orderable: false, render: function (data, type, row, meta) { var id = "'" + row.id + "'"; var script = encodeURI(angular.toJson(row)); var actionHtml = '<div class="btn-group">' + '<button type="button" class="btn btn-default btn-sm" title="编辑" ng-click="cacScriptListCtrlVm.views.editScript(\'' + script + '\')">' + '<span class="fa fa-pencil"></span>' + '</button>' + '<button type="button" class="btn btn-default btn-sm" title="删除" ng-click="cacScriptListCtrlVm.views.deleteScript(' + id + ')">' + '<span class="fa fa-remove"></span>' + '</button>' + '</div>'; return actionHtml; }, createdCell: function (nTd, sData, oData, iRow, iCol) { $compile(nTd)($scope); } } ] }; function init() { if (_appconfig.modules.cac.useLocalDb) { tableOption.ajaxSource = 'app/modules/cac/api/script.json'; $timeout(function () { vm.views.tableInstance = cacService.prepareDatatable(".scriptTableDiv .scriptTable", tableOption); }, 10); } else { tableOption.ajax = cacService.assembleDataTableUrl('/api/cac/audit/scripts'); $timeout(function () { vm.views.tableInstance = cacService.prepareDatatable(".scriptTableDiv .scriptTable", tableOption); }, 10); } }