Sort datatables dropdown filter

Question

I have a datatable, where I already made dropdowns for filtering my lines. My problem is that the values in the drop down itself aren't sorted...

Here is my code:

this.innerHTML = fnCreateSelect(oTable.fnGetColumnData(i), $("#" + i).val());
$('select', this).change(function () {
    var searchVal = $(this).val().replace(/\&/g, '&amp;');
    if (searchVal != '') {
        searchVal = '^' + searchVal + '$';
    }
    oTable.fnFilter(searchVal, i, true, false);
});

Thanks!

Tomer Amir · Accepted Answer · 2014-02-23 16:55:44Z

2

Ok, found the answer:

all that was needed to be done is to write oTable.fnGetColumnData(i).sort() instead of oTable.fnGetColumnData(i). Then I also wanted the sorting not to be case sensitive, so I changed it again to:

oTable.fnGetColumnData(i).sort(function(a, b) {
    if (a.toLowerCase() < b.toLowerCase()) return -1;
    if (a.toLowerCase() > b.toLowerCase()) return 1;
    return 0;
});

answered Feb 23, 2014 at 16:55

Tomer Amir

1,6154 gold badges35 silver badges56 bronze badges

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

Collectives™ on Stack Overflow

Sort datatables dropdown filter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related