jQuery DataTables Ordering By 2 columns

user_5525311 0
Viewed 8123

I am using jQuery DataTables to style and give functionality to one of my tables:

enter image description here

My Goal

Order by whether or not the type of funding is active or not.. which is what it is doing currently as you can see. Now, I would like to order the Funding column alphabetically.. so my wanted outcome should be:

Funding One
Funding Two
Funding Three
Funding Four
Alpha
Beta
Charlie
Test
test2

Here is what I have so far my datatables script:

var codeFundingTable = $("#Code-Funding-Table").DataTable({
    "bPaginate": false,
    "bFilter": false,
    "aoColumnDefs": [
        { "bSortable": false, "aTargets": [2] },
        { "bSearchable": false, "aTargets": [2] }
    ],
    "columns": [
        { "orderData": [1] },
        { "orderData": [0] }
    ]
});

So I am first ordering by column 1 (Active, 0-based) then by column 0 (Funding) but it is not doing it alphabetically.

How can I make this happen?

datatables jquery javascript
3 Answers

In my case, what helped me is this. I used data-order attribute to sort my tables.

data-order="[[ 0, "asc" ], [ 1, "asc" ]]
user_106891890
Related