Answers

• kthorngren Posts: 21,332Questions: 26Answers: 4,951

  September 22

  Use column().search()instead of search(). This way the default search input is not populated with the search term. If you want to perfrom a not compare then create a function, that is passed as the first parameter, input, to the column().search() API. The function can perform any comparison's you want.

  Kevin
• kthorngren Posts: 21,332Questions: 26Answers: 4,951

  September 22

  Another option is to use column().search.fixed(). See this thread.

  Kevin
• sjordan Posts: 36Questions: 10Answers: 0

  September 22 edited September 22

  Here's my updated filter:

  $("#mySelect").on("change", function () {
            const option = $(this).val();
  
            table
              .columns(1)
              .search((d) => {
                if (option === "Smith") {
                  return d.includes("smith");
                } else if (option === "NotSmith") {
                  return !d.includes("smith");
                }
                return true;
              })
              .draw();
          });
  

  Doesn't work. Is my syntax correct?

  Also note, I'm using DT1
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  September 22

  DataTables v1 does not support passing a function to the search() methods. You need DataTables 2 for that. Also, DataTables 1 is no longer supported, so if you can, I'd suggest updating.

  Allan
• sjordan Posts: 36Questions: 10Answers: 0

  September 22

  Any work around for DT1?
• kthorngren Posts: 21,332Questions: 26Answers: 4,951

  September 22

  Create a search plugin. Here is a running example.

  Kevin
• allan Posts: 63,498Questions: 1Answers: 10,471 Site admin

  September 23

  That example actually uses search.fixed() with a function search term now - it was updated for DataTables 2.

  It did use to use the old style $.fn.dataTable.ext.search.push(...) search functions, which is how it used to be done in DataTables 1. The code for that example is still in Github and you could base your solution off that if you can't upgrade. However, as I say, DT1 is no longer supported.

  Allan
• sjordan Posts: 36Questions: 10Answers: 0

  September 23

  Thank you Kevin and Allan. I did manage to get workaround.

  Upgrading to DT2 is desired. Client uses maybe a half dozen instances of DT and Editor across the app; I'd have to do a bit of testing for breaking changes.

  Appreciate your help