Second one

You may need to run filters on one Collection based on information in another related Collection. Here are a few examples of when that might happen:

• Book authors that also wrote screenplays (filters authors, uses screenplays).
• Products with a 5 star customer review (filters products, uses reviews).
• Accounts with active user login within the last 12 months (filters accounts, uses logins).

This can span across any number of relationally linked Collections. For example, you could filter for customers that bought rock songs, where the customers and genres Collections are linked by customers -> invoices -> invoice-items -> tracks -> genres.

You will notice a chevron_right icon beside relational Fields. When you click on any Alias Field, all the Fields for that associated Collection pop down. If you select one of these Fields, you can run Filters on the current Collection by Field values in a related Collection.

Here are step-by-step instructions on how to filter by Fields in other Collections: