Answers

• taouil Posts: 3Questions: 1Answers: 0

  October 2021 edited October 2021

  This is the JS code I use for the filter:

  this.api().columns([6]).every( function () {
                          var column = this;
                          var select = $('<select class="form-select form-select-solid" data-dropdown-parent="#FilterMenu" id="filter_floor"><option value=""></option></select>')
                              .appendTo( '#filter_3' )
                              .on( 'change', function () {
                                  var data = $.map( $(this).select2('data'), function( value, key ) {
                                      return value.text ? '^' + $.fn.dataTable.util.escapeRegex(value.text) + '$' : null;
                                              });
                                  if (data.length === 0) {
                                      data = [""];
                                  }
                                  var val = data.join('|');
                                  column
                                          .search( val ? val : '', true, false )
                                          .draw();
                              } );
  
                          column.data().unique().sort().each( function ( d, j ) {
                              var val = $('<div/>').html(d).text();
                              select.append( '<option value="' + val + '">' + val + '</option>' );
                          } );
                      } );
                      $('#filter_floor').select2({
                          placeholder: "Select a floor",
                          allowClear: true,
                          multiple: true,
                          dropdownParent: $("#FilterMenu")
                      });
                      $('#filter_floor').val(null).trigger('change');
                      $('#filter_floor').attr('multiple', 'multiple');
                      $("#filter_floor" + " option")[0].remove();
  
• kthorngren Posts: 20,425Questions: 26Answers: 4,794

  October 2021 Answer ✓

  Try removing .sort() from line 18 of your above code snippet.

  Kevin
• taouil Posts: 3Questions: 1Answers: 0

  October 2021

  @kthorngren Thank you for the answer, it's working perfectly.