# Is this filter possible in a list?

**URL:** <https://forum.adalo.com/t/is-this-filter-possible-in-a-list/36648>\
**Category:** Database\
**Created:** [February 25, 2023, 9:52am UTC](https://forum.adalo.com/t/is-this-filter-possible-in-a-list/36648 "2023-02-25T09:52:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Toms](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/toms/32/27427_2.png) [@Toms](https://forum.adalo.com/u/Toms)\
**Post date:** [February 25, 2023, 9:52am UTC](https://forum.adalo.com/t/is-this-filter-possible-in-a-list/36648/1 "2023-02-25T09:52:18Z")

</div>

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:

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/a/baa12d501d5345f729c31d14453e21fb18d59388.png)

Any suggestions?

---

<div class="post-metadata">

**Author:** ![Yongki](https://avatars.discourse-cdn.com/v4/letter/y/7c8e57/32.png) [@Yongki](https://forum.adalo.com/u/Yongki)\
**Post date:** [February 25, 2023, 1:21pm UTC](https://forum.adalo.com/t/is-this-filter-possible-in-a-list/36648/2 "2023-02-25T13:21:53Z")

</div>

Hi @Toms ,

You might want to check this,

> [@Relationship Filtering](https://forum.adalo.com/t/relationship-filtering/27114):
>
> 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. The above example are u…
