jQuery DataTables Ordering By 2 columns

Question

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

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?

What happens if you switch the orderData 1 and 0? Does it order by Funding only? — Bango
– Bango, Commented Jul 21, 2017 at 16:47
@Bango correct, it orders alphabetically without any regard for being active or not — Grizzly
– Grizzly, Commented Jul 21, 2017 at 16:53
can you create a fiddle with sample data..? Here is a starting point -> jsfiddle.net/0f9Ljfjr/948 — davidkonrad
– davidkonrad, Commented Jul 22, 2017 at 9:13

davidkonrad · Accepted Answer · 2017-07-22 09:26:28Z

22

It is a guess since we have no sample data. For example, what is the value of "active" (besides a checkbox is rendered)? But I believe you can just do

var table = $('#example').DataTable({
  order: [[1, 'asc'], [0, 'asc']]
})

active column is sorted first, if values is 0 and 1 asc should be used
first column is secondly sorted alpha, with respect of second column order

Here is a demo -> http://jsfiddle.net/0f9Ljfjr/949/ position is sorted first, then name is sorted within each position "type".

answered Jul 22, 2017 at 9:26

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Bango · Accepted Answer · 2017-07-21 16:57:42Z

0

Try this on for size

"columns": [
    { "orderData": [1,0] },

https://datatables.net/examples/basic_init/multi_col_sort.html

answered Jul 21, 2017 at 16:57

Bango

9667 silver badges19 bronze badges

2 Comments

Grizzly Over a year ago

sorry, this doesn't help. It would be the same as { "orderData": [0] }, { "orderData": [1] }

Bango Over a year ago

It 'would be' the same, if you did try it; or you did try it, and it is the same? Also note that your Active column contains HTML which oftentimes interferes with functionality like searching and sorting.

Omair Munir · Accepted Answer · 2022-07-11 10:17:36Z

0

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

data-order="[[ 0, &quot;asc&quot; ], [ 1, &quot;asc&quot; ]]

answered Jul 11, 2022 at 10:17

Omair Munir

14310 bronze badges

Collectives™ on Stack Overflow

jQuery DataTables Ordering By 2 columns

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related