filters in views not showing existing values

[dpavlov]

I have columns of type TEXT using a valid_if expression to get a drop down values from another table. 

I have a Table view from the table above, however when i want to use the filters i won't show any of the existing rows vales but it shows only a search option? 

Is this how it should be? And are filters showing values only for ENUM columns?

[Suvrutt_Gurjar · Accepted solution]

Yes, I believe your observation is correct that text columns with options through valid_if will show as "open" search.

If possible, you could convert that text column to enum column with base type as text , so that the filter options start showing. However, even with enum type column, please be aware of the following limitation.

Search Filter List not Alphabetically Ordered - Google Cloud Community