How to do 2 searches using select box?

[jungsu]

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?

[jmann]

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.

-Justin

[jungsu]

@jamnn
hello?
Thank you for your kind explanation.
You have solved the problem well.