Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  May 2021 edited May 2021 Answer ✓

  Yep, this example here shows how you can load queries. You could add that API call (searchBuilder.rebuild()) into your button's action function,

  Colin
• cj1005 Posts: 144Questions: 46Answers: 1

  May 2021

  Thank you Colin, I'll have a play
• cj1005 Posts: 144Questions: 46Answers: 1

  May 2021

  Hi Colin,

  I've added the code as described, but I'm getting the following error:

  "dataTables.searchBuilder.min.js:151 Uncaught TypeError: Cannot read property '_searchBuilder' of undefined"

  I've created 3 buttons, which all result in the same error as above.

  The code I've added is as follows:

  <script>
  var cSBActiveFilter = { "criteria": [ { "condition": "=", "data": "active", "value": [ "1" ] }, { "value": [] } ], "logic": "AND" };
  var cSBDeadFilter = { "criteria": [ { "condition": "=", "data": "active", "value": [ "0" ] }, { "value": [] } ], "logic": "AND" };
  </script>
  
  <button type="button" id="currentVehicles" >Current Vehicles</button>
  <button type="button" id="deadVehicles" >Deleted Vehicles</button>
  <button type="button" id="searchReset" >Reset</button>
  
  <script>
  $('#currentVehicles').on('click', function() {
      $('#vehiclesTable').DataTable().searchBuilder.rebuild(cSBActiveFilter);
  })
  $('#deadVehicles').on('click', function() {
      $('#vehiclesTable').DataTable().searchBuilder.rebuild(cSBDeadFilter);
  })
  $('#searchReset').on('click', function() {
      $('#vehiclesTable').DataTable().searchBuilder.rebuild();
  })
  </script>
  
  

  Any ideas?

  Cheers, Chris
• kthorngren Posts: 21,339Questions: 26Answers: 4,954

  May 2021 Answer ✓

  Uncaught TypeError: Cannot read property '_searchBuilder' of undefined"

  Verify that your table id is vehiclesTable. If you still need help please provide a link to your page or a test case replicating the issue so we can help debug.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin
• cj1005 Posts: 144Questions: 46Answers: 1

  May 2021

  Thank you, Kevin, you were right, I was using the variable reference of the table not the actual table name