Filter on a join table attribute not working in postgres

[Anum]

I am trying to filter the table on customerId obtained by joining users and registrations.

SELECT "Users"."Customer ID" AS "Customer ID", count(*) AS "count"
FROM "public"."registrations"
LEFT JOIN "public"."users" "Users" ON "public"."registrations"."User ID" = "Users"."ID"
WHERE "public"."registrations"."Show ID" is not null and "Users"."Customer ID" is not null  [[and {{date}}]] **[[and {{customer}}]]**
GROUP BY "Users"."Customer ID"
ORDER BY "count" DESC, "Users"."Customer ID" ASC
LIMIT 20

This ends up giving me an error

[flamber]

Hi @Anum
I'm sure that we have been over this before. You cannot use table aliases with Field Filters:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#field-filter-gotchas

[Anum]

Yes, it was working fine in mysql. I have removed name aliasing but still it does not work. Can you figure it out?

SELECT "Customer ID", count(*) AS "count"
FROM "public"."registrations"
LEFT JOIN "public"."users" ON "public"."registrations"."User ID" = "ID"
WHERE "public"."registrations"."Show ID" is not null and "Customer ID" is not null  [[and {{date}}]] [[and {{customer}}]]
GROUP BY "Customer ID"
ORDER BY "count" DESC, "Customer ID" ASC
LIMIT 20

[flamber]

@Anum I doubt it was working on MySQL, since it would cause similar error.
Your "ID" column does not have a table reference.

[Anum]

it worked. thank you so much.