I have an SQL question where I want to use a Field Filter variable. However, I don’t want every value of the selected table to be listed on the dropdown (or autocomplete); just some of them.
I have a variable called
state in my SQL query, but in my database base I have a table called
terms, which contains the term name and the category it belongs to.
Id | Name | Category
0 | Rio de Janeiro | State
1 | Minas Gerais | State
28 | Caldas | City
29 | Recife | City
In my dropdown, I only want to show term names whose category is
It this possible?