Answers

• kthorngren Posts: 21,537Questions: 26Answers: 4,988

  July 2020

  I'm not sure how to specifically answer your questions without seeing a test case with your specific data. But the code the builds the select is this:

                      column.data().unique().sort().each( function ( d, j ) {
                          select.append( '<option value="'+d+'">'+d+'</option>' )
                      } );
  

  You can modify it to suit your needs. If you still need help please build a simple test case with an example of your data so we can help you with your code.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• Haris Zafar Posts: 2Questions: 1Answers: 0

  July 2020

  @kthorngren Here is the image link
  ibb.co/kDPpSYk
  maybe it will help you to Understand the problem

  Thanks
• kthorngren Posts: 21,537Questions: 26Answers: 4,988

  July 2020

  The best way to get help is if you build a simple test case with your data.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• yajuvendra1990 Posts: 1Questions: 0Answers: 0

  November 2020 edited November 2020

  here are the solution

  initComplete: function () {
      this.api().
      columns([1]).every( function () {
          var column = this;
          var select = jQuery('<select id="coulumn1"><option value=""></option></select>')
          .appendTo( jQuery(column.header()).empty() )
          .on( 'change', function () {
          var val = jQuery.fn.dataTable.util.escapeRegex(
              jQuery(this).val()
          );
          column
          .search( this.value )
          .draw();
          } );
          column.data().unique().sort().each( function( d, j ) {      
                 var nameArr = d.split(",");
                  nameArr.forEach(function(number) {                
                      var optionExists = ($("#coulumn1 option[value="+number+"]").length > 0);
                      if(!optionExists){
                          select.append( '<option value="'+number+'">'+number+'</option>' );
                      }                    
                  });                           
          } );
      } );
  }
  
• colin Posts: 15,240Questions: 1Answers: 2,599

  November 2020

  Looks good, thanks for posting,

  Colin
• Jayed Posts: 2Questions: 0Answers: 0

  June 2021

  Hey @colin, I am a fan of your codes. I understand many things by studying your codes
  I am using this for filter

             initComplete: function () {
                  this.api().columns([2,3,4,5,6,7,8]).every( function () {
                      var column = this;
                      console.log(this.index())
                      var select = $('<select><option value="">All</option></select>')
                          .appendTo(  $('thead tr:eq(1) th:eq(' + this.index()  + ')') )
                          .on( 'change', function () {
                              var val = $.fn.dataTable.util.escapeRegex(
                                  $(this).val()
                              );
  
                              column
                                  .search( val ? '^'+val+'$' : '', true, false )
                                  .draw();
                          } );
  
                      column.data().unique().sort().each( function ( d, j ) {
                          select.append( '<option value="'+d+'">'+d+'</option>' )
                      } );
                  } );
              }
  

  I have comma separated values in 4th column. How I can use separate values as a option of dropdown filter?
• colin Posts: 15,240Questions: 1Answers: 2,599

  June 2021

  We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

  Cheers,

  Colin
• Jayed Posts: 2Questions: 0Answers: 0

  June 2021 edited June 2021

  Below is the test case @colin :
  http://live.datatables.net/hibidibu/1/edit?html,css,js,output
  Please check the filter in 2nd and 3rd columns and comma separated values
• kthorngren Posts: 21,537Questions: 26Answers: 4,988

  June 2021

  See if this thread gets you started. See the example from the thread. For a complete solution it will probably require two loops; the first building an array of the split items making sure the array only contains unique data. The second looping through in sorted order to build the selects.

  Kevin