Sorting jQuery DataTables from a single Select Option

Question

I've been trying to see if this is even possible, so let me explain what I'm looking for.

I have a basic table that I'm making sortable with jQuery DataTables, no custom options, just the simple basic initialization.

$("#myTable").DataTable();

Is there a way that I connect myTable to a select form element, and have the table be sortable by that select dropdown ONLY?

This might help, stackoverflow.com/q/16565568/1793718 Basically if the user chooses an option in the select element one will expect the column to be filtered(instead of sorting). So I think its better to filter the data and display it. Please see my question here, stackoverflow.com/q/39169291/1793718 I couldn't find a better solution. You might need to write some custom plugin to do that. Or head to datatables.net/forums and post your question there for other solutions — Lucky
– Lucky, Commented Jul 12, 2017 at 14:07

Gyrocode.com · Accepted Answer · 2017-07-18 15:22:59Z

0

You can disable sorting for each column using columnDefs.orderable option and then sort the table with order() API method when value of drop-down control changes.

For example:

var table = $('#example').DataTable({
   'columnDefs': [
      { 'orderable': false, 'targets': '_all' }
   ],
   'order': [0, 'asc']       
});

$('#example-sort').on('change', function(){
   table.order([$(this).val(), 'asc']).draw();
})

See this example for code and demonstration.

answered Jul 18, 2017 at 15:22

Gyrocode.com

59k16 gold badges157 silver badges192 bronze badges

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

Collectives™ on Stack Overflow

Sorting jQuery DataTables from a single Select Option

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related