# Filtering data with AND and OR
**URL:** https://community.glideapps.com/t/filtering-data-with-and-and-or/78503
**Category:** Ask for Help
**Created:** [December 10, 2024, 8:43pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503 "2024-12-10T20:43:22Z")
**Posts on this page:** 15
**Page:** 1
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [December 10, 2024, 8:43pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/1 "2024-12-10T20:43:23Z")
Hello Gliders! My component is COLLECTION and in OPTIONS I would like to filter like this:
1)TYPE is EXPENSE
AND
2) UserID is RowID OR UserID is EMPTY
But apparently you can only use AND or OR throughout. Can´t you mix AND and OR?
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [December 10, 2024, 9:42pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/2 "2024-12-10T21:42:32Z")
No you can’t mix both unfortunately.
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [December 10, 2024, 9:45pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/3 "2024-12-10T21:45:21Z")
But, as a workaround, you can make multiple if else then else columns with specifics conditions, negation conditions to make it possible to use only AND or only OR. That is what I usually do!
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [December 10, 2024, 10:11pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/4 "2024-12-10T22:11:09Z")
Yes! The if-then-else column solves the issue. Thanks!
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [December 10, 2024, 10:18pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/5 "2024-12-10T22:18:58Z")
Anytime!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 11, 2024, 12:06am UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/6 "2024-12-11T00:06:55Z")
Your If-Then-Else would look like this I believe.
If TYPE is not EXPENSE then false.
If UserID is EMPTY then true.
Is UserID is not RowID then false.
Else true.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [December 11, 2024, 1:51pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/7 "2024-12-11T13:51:36Z")
Hola Martín,
When this case gets complicated due to new conditionals appearing, I prefer to use this short JS code to handle the logic and use the value “true” as a filter parameter in Glide components.
Something like this:
```auto
if ((p1 == "EXPENSE") && (p2 == "yourRowID" || p2 == ""))
return true
```
just play with the conditional AND (&&) / OR (||) by putting your cases in the _IF statement_ to create an easy-to-understand logic
An _If-Then-Else_ column using more than 4-5 combinations (with AND/OR mixtures) can drive anyone crazy 🥴
Saludos!
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [December 11, 2024, 2:56pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/8 "2024-12-11T14:56:03Z")
I didn’t think about that. You are right, this is so much more powerful!
---
### Author:  [@mbraunperu](https://community.glideapps.com/u/mbraunperu)
#### Post date: [December 11, 2024, 3:42pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/9 "2024-12-11T15:42:29Z")
Awesome! Muchas gracias!!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 12, 2024, 12:40am UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/10 "2024-12-12T00:40:02Z")
Please beware of running JavaScript on bigger tables though. If there’s a “native” solution like If-Then-Else, I would prioritize that.
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [December 12, 2024, 2:24am UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/11 "2024-12-12T02:24:50Z")
Ok, so this [Filtering data with AND and OR - #3 by MaximeBaker](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/3) is better native solution then.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [December 12, 2024, 9:46pm UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/12 "2024-12-12T21:46:23Z")
Again … all will depend on the size of your table and the amount of columns you have to create to get a simple result when you have many OR/AND as conditionals in an ITE column.
If I have more than 5-6 conditions and a rare mixture of ON/AND, visually is a little complex understand the logic and worse, modify the logic due to a new condition can be a nightmare.
My rule is simple and I think it applies to save a large amount of data when the APP is running:
- if I can get a result using simple a JS code (1 column) instead of using 3-4 columns with native features (or no code solution), I will choose the JS option without fear in proportion 20-1
If my table has 15k rows, why do I need to create other 45k-60k new rows (by 3-4 columns) only to use a native solution?
It doesn’t make sense to me.
Saludos a todos!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [December 13, 2024, 1:25am UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/13 "2024-12-13T01:25:33Z")
From what I gather in performance mode, anything related to time is slow as hell, then JavaScript is next.
I agree that if you have a very complex case, JavaScript might be better for debugging purposes, but in this case it comes out like this for my 1000 rows sample.
The results are identical.
But the time to calculate them is not.
JS took 11ms, ITE took 3ms.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [December 13, 2024, 2:12am UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/14 "2024-12-13T02:12:22Z")
Nice test!
In the end I’m not going to fight for 8ms… I invite you a coffee! 😉
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [December 20, 2024, 2:13am UTC](https://community.glideapps.com/t/filtering-data-with-and-and-or/78503/15 "2024-12-20T02:13:13Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.