How to do 2 searches using select box?

I want to change the search condition using the select box, but it does not work when I enter the search condition. What should I do?

Hi @jungsu,

I was able to get a SQL query to dynamically filter on column and value with a query structured like the below. A few things to note:

  • The first part of the WHERE clause is to show all records if there is no value entered
  • The second part casts the column to a VARCHAR as we're using a text input component
  • I used the ILIKE operator so the query doesn't care about upper/lowercase
  • The SQL resource needs to have prepared statements disabled since we're changing the query structure with the dynamic column names.


Thank you for your kind explanation.
You have solved the problem well.

1 Like