is it poss. to have a multi sort where the prime is a fixed column & secondary dosnt need shift

sfurey

Hello - I was wondering if this is possible...

I'd like my datatable to always have my primary sort to be fixed(the priority column below which is an int dataType) and the secondary sort to be whichever column they clicked on without the user having to hold down the shift key.

My users would not know to do that.

Any help would be greatly appreciated.

thanks in advance!!

    $('#example').DataTable({
        "processing": true,
        "serverSide": false,
        "ajax": 'http://localhost/3d/Handler2.ashx',
        "columns": [
            { "data": "ACC", "sClass": "displayNone" }
            , { "data": "Patient", "render": function (data, type, full, meta) { return getPatient(data) } }
            , { "data": "ACC" }
            , { "data": "ExamCode" }
            , { "data": "Status" }
            , { "data": "Resource" }
            , { "data": "Scheduled" }
            , { "data": "Priority", "render": function (data, type, full, meta) { return getPriority(data) } }
            , { "data": "Document", "sClass": "centerVert", "orderable": false, "render": function (data, type, full, meta) { return getDocument(data, full) } }
        ]
    });