How to write query for the filter in retool app
You can make a temporary state and set it to the current value of the select input. To do this you have to create an event handler on the select input under interactions. Choose temporary state and select the temporary state you created. After that you’ll have to use {{self.value}}
as the value you set.
In your table query you can use the state value as your variable. Something like:
SELECT * FROM table WHERE column=myTemporaryState.value
More info:
You can also try out an example template. They usually have a filter with a table:
Try it out. Then look under the hood.