Answers

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

  September 2022 Answer ✓

  Have an input field, where we can enter in data (in our case we will scan a barcode) to search in the first column, if there is a match, select that row.

  Create a change event or whatever is appropriate, to use to find the row to select. Use row() with the row-selector as a function to match the bar code.

  Are you planning to use the Select extension? If you are then use row().select() to select the row found with the above step. See this example.

  When finished searching, we then hit edit to do whatever task is needed for all selected rows.

  If using the Select extension you can get the selected rows using rows() with the selector-modifier of {selected: true}. You can then perform the desired tasks with those rows.

  Kevin
• YoDavish Posts: 123Questions: 46Answers: 3

  September 2022

  @kthorngren

  So I got the code almost working perfectly. I the input waiting for a change event and then searches every row to select:

  $("#searchInput").change(function(){
      var searchValue = document.getElementById("searchInput").value;
      table.rows(':contains("'+searchValue+'")').select();
      document.getElementById("searchInput").value = "";
  });
  

  The last few issues I have are,
  1.Search only first column of every row rather than ever column of each row
  2 The ":contains(VALUE)" works, however, can we do an exact match rather than a trailing wild character search.
• kthorngren Posts: 21,330Questions: 26Answers: 4,951

  September 2022 Answer ✓

  As I said before use the row-selector as a function. You should be able to meet both of your requirements this way.

  Kevin