Field filter does not accept and pass values

Bug reports
1

The following query:

select email, sum(amount) from users
join orders on orders.user_id = users.id
where {{user}}
group by email

with a single address (e.g. abc@xyz.com) applied as a field filter returns a nonfiltered list of all the emails in the users table and their respective aggreagated sums from the joined orders table instead of a single pair defined by the filter. Neither square brackets nor rearranging multiple wheres help.

Despite changing the data type to anything in Admin, it has no success. Not to mention, email type supports no field filtering and I'm forced to use category by default.

MB version 41.4, yet the problem has persisted on every previous version.

I also tried passing an email via plain text filter using:
email = {{user}}
It returned:
Cannot run the query: missing required parameters: #{"user"}
That possibly hints some wrong behaviour of these filters.

Diagnostic data:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/96.0.4664.110 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
    "java.vendor": "Ubuntu",
    "java.vendor.url": "https://ubuntu.com/",
    "java.version": "11.0.11",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.11+9-Ubuntu-0ubuntu2.18.04",
    "os.name": "Linux",
    "os.version": "4.15.0-151-generic",
    "user.language": "en",
    "user.timezone": "Europe/Berlin"
  },
  "metabase-info": {
    "databases": [
      "googleanalytics",
      "postgres",
      "mongo"
    ],
    "hosting-env": "unknown",
    "application-database": "h2",
    "application-database-details": {
      "database": {
        "name": "H2",
        "version": "1.4.197 (2018-03-18)"
      },
      "jdbc-driver": {
        "name": "H2 JDBC Driver",
        "version": "1.4.197 (2018-03-18)"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2021-12-10",
      "tag": "v0.41.4",
      "branch": "release-x.41.4",
      "hash": "471cfb9"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
2

Hi @123
It sounds like you are trying to use the SQL question in another question (Saved Questions, or via Explore results). Is that correct? If yes, then you're seeing this issue:
https://github.com/metabase/metabase/issues/6449 - upvote by clicking :+1: on the first post

3

No, I don't. The tables are from postgres

4

@123 Okay, I cannot reproduce on any database types. Try reproducing the Sample Dataset:
https://www.metabase.com/learn/sql-questions/field-filters