Is this filter possible in a list?

[Toms]

I have the following situation:

• A chatroom has a 1-n with relationship with classes (so a chatroom always has 1 class and a class can have multiple chatrooms).
• A teacher has a n-n relationship with classes. (so a teacher can have multiple classes and classes can have multiple teachers)

When I log in as a teacher I want to see a list of all chatrooms that share the same classes as I have.

Simple example:

Chatrooms:
ID - Class
1 - class A
2 - class B
3 - class A
4 - class C

Teachers:
Name - Class
John - class A, class B
Maria - class A, class C
Harry - class C

So when I log in as John, I want to see a list of chatroom 1, 2 and 3.
When I log in as Maria, I want to see a list of chatrooms 1, 3 and 4
As Harry, I only want to see chatroom 4.

For some reason I cannot filter it like this:

Any suggestions?

[Yongki]

Hi @Toms ,

You might want to check this,

Relationship Filtering

PSABH Series presents relationship filtering example app. If we want to filter by interests or skills that users have, we can use relationship filtering to do that. There are 2 different operators, the most common way is AND, which is users must have both interests to be shown, but we can use OR to display users that have at least interests asked. [Screen Shot 2022-05-12 at 7.45.31 AM] [Screen Shot 2022-05-12 at 8.15.45 AM] [Screen Shot 2022-05-12 at 8.15.53 AM] The above example are u…