Currently we are using 29.3 version of metabase.
We want to know how the filters work on custom SQL queries.
Suppose we use the table data directly, we are able to apply filter on a column and it suggests the different values from that column to apply the filter on.(image attached in the reply)
But if we try to do the same thing using custom SQL query we are able to select the column but not able to get the values from that column and asking us to give the text value to apply the filter as shown in the second image in pdf.
Can you suggest on this. Or should we use it in a different way to auto populate the values of that column.
Also is this added in the newer versions?