Answers

• kthorngren Posts: 21,351Questions: 26Answers: 4,955

  December 2022

  If you are not using dom: 'Qlfrtip' how are you initializing SearchBuilder?

  This test case shows using the above code with API initialization and it limits to the columns specified:
  http://live.datatables.net/girajobe/1/edit

  Please provide a link to your page or update the test case to show the issue.

  Kevin
• straetch Posts: 5Questions: 3Answers: 0

  December 2022

  My JQuery skills are limited. I made my code by assembling code snippits from the excellent examples and the forum posts.
  This was a section of my code with a button to activate searchBuilder:

  var table = $('#example').DataTable({
          buttons: [
              {
                  extend: 'searchBuilder',
              }],
          dom: 'Bfrtip',
          searchBuilder: {    
              columns: [3,4,5],   // has no effect
              etc.
          },
  

  SearchBuilder was fully operational except for the Data drop-down list that listed all columns. (with dom: 'Qlfrtip' that also works, but is then not button-driven).
  I dug deeper in the examples and found this:

  var table = $('#example').DataTable({
          buttons: [
              {
                  extend: 'searchBuilder',
                  config: {
                      columns: [3,4,5]
                  }
              }]
          dom: 'Bfrtip',
  

  This works.
  The direct relationship between a button definition and the Data dropdown is unclear to me.
• allan Posts: 63,542Questions: 1Answers: 10,476 Site admin

  December 2022 Answer ✓

  The searchBuilder button type creates its own instance of SearchBuilder - you need to pass any configuration options you want for it to its config option.

  That and the searchBuilder options are really just short hand ways of saying new DataTable.SearchBuilder(table, options);.

  Allan