Answers

• AshutoshD Posts: 2Questions: 1Answers: 0

  March 2023 edited March 2023

  URL is as following - https://datatables.net/examples/api/multi_filter_select.html

  In the above link ** is added.

  and below is the code which I am using.

  $(document).ready(function () {
      $('#example').DataTable({
          initComplete: function () {
              this.api()
                  .columns()
                  .every(function () {
                      var column = this;
                      var select = $('<select><option value=""></option></select>')
                          .appendTo($(column.footer()).empty())
                          .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>');
                          });
                  });
          },
      });
  });
  

  Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• allan Posts: 63,540Questions: 1Answers: 10,476 Site admin

  March 2023 edited March 2023

  Change this.api().columns() to select only the columns that you want to add a filter to (see columns() for details). For example:

  this.api().columns('.dropdown-search')
  

  to select all columns with that class.

  In future, please link to a test case showing the issue, per the forum rules.

  Thanks,
  Allan