Dynamic data filter using InputField

Question

I would like to filter data in the table dynamically. Here is the example of the code:

search = "da";
data = {Range[100],ResourceFunction["RandomString"][{"a", "d", "e", "n", "r", "s"}, {100, 5}]} // Transpose;
Column@{
   InputField[Dynamic@search, String],
   Dynamic@search,
   Cases[data, {_, x_} /; StringContainsQ[x, search]] // TableView
 }

Its dynamically updates 'search' variable on the change of InputField, but not when I apply Cases filter. When I put 'Dynamic@search instead' of 'search' inside of 'StringContainsQ' it return the error message "Element da is not a valid string or pattern element in da". I will be appreciated if somebody could help me to solve the issue.

Answer 1

Try:

search = "da";
SeedRandom[1];
data = {Range[100], 
    ResourceFunction["RandomString"][{"a", "d", "e", "n", "r", 
      "s"}, {100, 5}]} // Transpose;
Column@{InputField[Dynamic[search], String], Dynamic@search, 
    Cases[data, {_, x_} /; StringContainsQ[x, search]] // TableView //
      Dynamic} // Print;

and with a different input of "aa":