Column filters aren't a list

Get Help
1

Sorry if this isn’t the right format - first timer here.

When I ask a new question, and select a raw table from our DB, I’m able to select the column header in the table view, select filter, and select from a list of options (presumably because that column is an enum in our postgres DB).

However, if the underlying data was another question, and not one of our postgres tables, i do not get a nice list to select from. instead, it wants me to enter a string, but then gives me an error saying that there was a type mismatch between an enum and a string.

Is this expected? Is there a way to make it so I can filter columns in the same way as I can when the underlying table was a postgres table?

2

Hi @hollywood
You are looking for this issue:
https://github.com/metabase/metabase/issues/5594 - upvote by clicking :+1: on the first post

3

Got it, thanks

4

@flamber is there a workaround for this? i can’t even filter these tables now because all i’m presented with is the option to see if they are equal or not equal to certain strings, which fails because the underlying postgres column is an enum (and comparing an enum to a string fails).

5

@hollywood Creating a database view is currently the only workaround, so Metabase just sees that as a table.
You are also hitting this issue:
https://github.com/metabase/metabase/issues/7092 - upvote by clicking :+1: on the first post