Error when using field filter?

When I use text as a filter condition, I can query by entering the corresponding value, but when I select the corresponding value when I use the field filter, an error is reported. The error is “unknown column user.name in filed list”. I did not set it right. ?

Hi @xiaojun
Please read this: https://www.metabase.com/blog/field-filters/index.html
You cannot use Field Filter with table aliases:
https://github.com/metabase/metabase/issues/3324 - upvote by clicking :+1: on the first post