jquery datatables question

Question

EDIT Nevermind... I really was missing the obvious... duh.

I have a five-column table and am using jquery.datatables.js (http://www.datatables.net/). I'm trying to figure out how to remove sorting for the first and fifth columns so that it's not an option at all...

I've tried the function below, but it's still adding a sort to the columns:

$('#searchlist').dataTable({
    "bJQueryUI": true,
    "sPaginationType": "full_numbers",
    "aoColumns": [
                    null,
                    { "asSorting": [ "asc" ] },
                    { "asSorting": [ "desc", "asc" ] },
                    { "asSorting": [ "desc", "asc" ] },
                    null
                ]
});

Am I missing something?

If you answered your own question, you should post the answer below so that others can benefit from your experience. — David Pfeffer
– David Pfeffer, Commented Mar 7, 2010 at 17:26

adsarasin · Accepted Answer · 2012-04-19 17:56:08Z

3

You could also use aoColumnDefs.

$('#searchlist').dataTable({
     "bJQueryUI": true,
     "sPaginationType": "full_numbers",
     "aoColumnDefs": [
            {"bSortable":false, 'aTargets': [0, 4]},
            {"bSortable":true, "asSorting": [ "asc" ], 'aTargets': [1]},
            {"bSortable":true,"asSorting": [ "desc", "asc" ], 'aTargets': [2, 3] },
      ]
});

answered Apr 19, 2012 at 17:56

adsarasin

414 bronze badges

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

Comments

Rbacarin · Accepted Answer · 2010-05-21 20:31:23Z

0

use "bSortable": false

answered May 21, 2010 at 20:31

Rbacarin

7076 silver badges12 bronze badges

Comments

Patrik Lindström · Accepted Answer · 2012-01-01 19:35:47Z

0

$('#searchlist').dataTable({
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"aoColumns": [
                {"bSortable":false},
                {"bSortable":true, "asSorting": [ "asc" ] },
                {"bSortable":true,"asSorting": [ "desc", "asc" ] },
                {"bSortable":true, "asSorting": [ "desc", "asc" ] },
                {"bSortable":false}
            ]
});

answered Jan 1, 2012 at 19:35

Patrik Lindström

1,1573 gold badges15 silver badges26 bronze badges

Collectives™ on Stack Overflow

jquery datatables question

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related