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);
            }
        }

 

转载于:https://www.cnblogs.com/zml-java/p/9321991.html