Deep filtering with relational table

Feature(s) impacted

Filtering

Observed behavior

Not able to use fields from the foreign table to filter

Expected behavior

Should be able to use fields from the foreign table to filter

Context

User Emails table stores foreign key of Users table. How can I filter using the fields from Users table?
I tried the following. But it shows “No records match your filter” which is wrong because the same filter works in the Users table.

  • Organization name: Project-V-Org
  • Project name: Project-V-Admin-Panel
  • Environment name: Production
  • Database type: MongoDB
  • Recent changes made on your end if any: NA…