# Filter from Array Column

**URL:** <https://community.glideapps.com/t/filter-from-array-column/7462>\
**Category:** Report a Bug\
**Created:** [April 20, 2020, 9:50pm UTC](https://community.glideapps.com/t/filter-from-array-column/7462 "2020-04-20T21:50:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RyanThomas](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@RyanThomas](https://community.glideapps.com/u/RyanThomas)\
**Post date:** [April 20, 2020, 9:50pm UTC](https://community.glideapps.com/t/filter-from-array-column/7462/1 "2020-04-20T21:50:45Z")

</div>

My app’s URL: [bft3f.glideapp.io](http://bft3f.glideapp.io)

I have filtered by an array column in my app. As a result multiple columns fields are in this filter.

 ![Screen Shot 2020-04-19 at 7.40.30 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/bdb407504fd3c9234183d6384429a1b5baedeb82.png)

So I selected Exterior and Cool, so that I can show all images that are exterior and have cool colors. So then I go back to my screen

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/5bc32d15f9866d9981f964d59d4890e981e05f64.jpeg)

The issue is the first two results are interiors even though exterior is selected as the filter.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/a/a7eef6a57bcd6d052c84a2a6f208c2b75d882b67.jpeg)

If I go into the search bar and search for EXT, the first two results go away.

I’m not sure what the functionality of filtering array columns should be, but I would expect that if you selected two items to filter, it would show items that match those two items.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [April 20, 2020, 10:17pm UTC](https://community.glideapps.com/t/filter-from-array-column/7462/2 "2020-04-20T22:17:58Z")

</div>

I suppose it was designed as an OR filter, so you can select to see Filter 1 OR Filter 2 instead of Filter 1 AND Filter 2. I’m not sure of a good workaround other than creating templates that join multiple values together, but I can see that not working well for you. In most cases, the filter would relate to a single type of category where you are filter by several types of categories or keywords.

This would be a good argument for allowing an option to pick AND or OR filters. Ideally you would be able to build your own filtering by having dynamic if/then columns that compare different column values or filter by a column value instead of static values, or allow dynamic if/then compares in a relation column.

---

<div class="post-metadata">

**Author:** ![RyanThomas](https://avatars.discourse-cdn.com/v4/letter/r/ba8739/32.png) [@RyanThomas](https://community.glideapps.com/u/RyanThomas)\
**Post date:** [April 20, 2020, 10:21pm UTC](https://community.glideapps.com/t/filter-from-array-column/7462/3 "2020-04-20T22:21:10Z")

</div>

Yeah, I was a little nervous this was designed as an or filter which seems a bit counter intuitive to me. Figured I would bring it up because the documentation is not 100% clear as to how this was designed.