Field filter not working whereas text filter is working with the same query

Field filter

Text filter

@Anum

  1. Post "Diagnostic info" from Admin > Troubleshooting.
  2. Post which database type you are querying.
  3. You are using a different filter table reference than what you are using in your query.
    Read this: https://www.metabase.com/learn/sql-questions/field-filters.html