# Filter data with 2 "and" connectors and multiple "or" connectors
**URL:** https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509
**Category:** Ask for Help
**Created:** [May 20, 2024, 5:52pm UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509 "2024-05-20T17:52:11Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [May 20, 2024, 5:52pm UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/1 "2024-05-20T17:52:11Z")
Hello,
is there any way to filter data with a mix of “and” connectors and “or” connectors.
In the collection components I can only use either “and” or “or” connectors.
I somehow managed to get a filter option in the navigation tab (if I show multiple collections under “options” the filter option appears).
I thought I could set “and” connectors and in the collection components “or” connectors. But unfortunately the filter in the navigation tab doesn’t work.
Any other ideas one could think of?
Thank you!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 20, 2024, 6:37pm UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/2 "2024-05-20T18:37:20Z")
Can you explain how your filter would be set up if it you could set it up the way you want? There are various workarounds, and sometimes you just need to change your thinking a little bit.
---
### Author:  [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [May 21, 2024, 6:09pm UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/3 "2024-05-21T18:09:43Z")
Yes, of course.
I would like to filter out all “draft” elements. If a data row is set to “draft” (by a TRUE / FALSE switch), that data should not be shown.
On top of that I want to filter data based on different OR paramenters:
- some posts are for all members
- some posts are specifically for one member (if the email in the data equals the email of the user)
- and some posts are for certain user categories
What I am missing is to filter out posts that are on “draft” status.
Is there a way to to this:
Don’t show posts where “Draft IS NOT TRUE” and show posts where (posts for all members OR posts for members category OR email equals user email).
I thought I could filter out the posts on draft on the navigation tab, but that filter doesn’t work. I hope I could explain myself.
Thank you very much for your help!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 21, 2024, 8:07pm UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/4 "2024-05-21T20:07:28Z")
> [@Alexdz](#):
>
> Don’t show posts where “Draft IS NOT TRUE” and show posts where (posts for all members OR posts for members category OR email equals user email).
Ok, a case like this is best done in the table itself with an IF column. I would set it up like this:
```auto
IF Draft is checked THEN false
ELSEIF AllMembers THEN true
ELSEIF Category THEN true
ELSEIF Email is User Email THEN true
ELSE false
```
With this, your filter only needs to look at the single IF column value. If the result is true, then show that row.
---
### Author:  [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [May 25, 2024, 8:11pm UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/5 "2024-05-25T20:11:29Z")
Yes, this is genius!! I guess I just need to make the column user specific and that’s it. I will try this. I just had eye surgery and I am starting to see better, but I need some time off screen. 🙂
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [May 26, 2024, 3:05am UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/6 "2024-05-26T03:05:58Z")
Not sure what you need to be user specific, but computed columns will become user specific if any of its source columns are user specific. That’s because most computed columns are computed on the user’s device based on the data that’s available to that user.
---
### Author:  [@Alexdz](https://community.glideapps.com/u/Alexdz)
#### Post date: [May 26, 2024, 7:04am UTC](https://community.glideapps.com/t/filter-data-with-2-and-connectors-and-multiple-or-connectors/73509/7 "2024-05-26T07:04:43Z")
I see… My question user categories are dynamic, meaning I have a query to pull in the relevant user emails.
In order to determine if a user is part of a category I would make a query
Ifelse user category contains user email.
But you are right, I probably don’t need it to make user specific, since it’s done based on the user email anyways.
Thanks a lot Jeff!