Answers

• allan Posts: 64,411Questions: 1Answers: 10,635 Site admin

  August 2018 Answer ✓

  See this example.

  Allan
• hAtul89 Posts: 12Questions: 7Answers: 0

  August 2018 edited August 2018

  @allan
  I expected this to get the search input to work with the selected values of the <select> input.
  (It doesn't..)
• kthorngren Posts: 21,983Questions: 26Answers: 5,077

  August 2018

  Maybe you can post a running example of what you are trying to do so we can help debug.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• allan Posts: 64,411Questions: 1Answers: 10,635 Site admin

  August 2018

  Right no it doesn't. The live DOM sorting does not also consider filtering. You'd need to use a custom filter for that.

  That is an area of limitation I'm aware of in DataTables, but the fixes I've thought of so far all have heavy performance issues.

  Allan
• midomimi Posts: 2Questions: 1Answers: 0

  December 2019

  Hi @allan and All,
  I modified an example found in a forum to write custom filters (select option, textarea ..) idea is to write my regexp that will be used by search function to filter. It is working, but please let me know your thoughts (if it is good or it sucks
  *_indexes variables (for example select_options_indexes) are indexes of columns depending on their type, and that I provide at beginning of script

     // Apply the search
      table.columns().every( function (index) {
        // that is column
        var that = this;
        $( 'input', this.footer() ).on( 'keyup change clear search', function () {
          that=table.columns(index);
          // this is the input searched string typed in the column search field
          if ( that.search() !== this.value ) {
            column_search_string=this.value;
            column_index=index;
            if (input_indexes.includes(index)) {
  
              if (this.value !== '') {
                  regex_expr='<input type="text".*value=".*'+this.value+'.*" maxlength=.*\>';
                  regex=true;
                  smart=false;
              }
              // when search text is cleared on input text column, there is no value attribute in the html input attrbute
              // so regexpr will not match
              else {
                  regex_expr='';
                  regex=false;
                  smart=false;
              }
  
            }
            else if (select_options_indexes.includes(index)) {
              regex_expr='[^]*selected="">[^<]*'+this.value+'.*</option>[^]*';
              regex=true;
              smart=false;
            }
            else if (text_area_indexes.includes(index)) {
              regex_expr=this.value;
              regex=false;
              smart=true;
            }
            else if (simple_text_indexes.includes(index)) {
              regex_expr=this.value;
              regex=false;
              smart=true;
            }          
            search_col=that.search(regex_expr, regex, smart);
            search_col.draw();
            }
          } );
  
        } );
  } );
  
  

  thank you very much.