Category filter gives wrong results when used with text filter syntax

Metabase version 0.31.2 with mySQL database

It seems that when you use a syntax designed for text filter syntax and add a category type filter, the result of the query (without any error message) is wrong.

More details and open issue in github:

Hi Eva,
It took me a little time to understand the issue, since I didn’t understand “category variable” and “category type”, but can see you’re talking about “Field Filter” - you might want to update that.
But anything that will help people with writing the correct query, when using filters would be great, since it’s one of the most common problems.

1 Like

Hi @flamber, very good point, thanks! Will change the wording (I thought “variable” is mostly used as the whole setting is called that way).