# Using an array in Query column "Filter by" **URL:** \ **Category:** Ask for Help\ **Created:** [September 28, 2023, 6:45am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594 "2023-09-28T06:45:30Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [September 28, 2023, 6:45am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594/1 "2023-09-28T06:45:30Z")
When working with a query column, I have noticed that it doesn’t seem to allow the use of an array in the filtering. E.g. I am trying to find rows in the source where a value is included in / contained in an array. Is this a limitation? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 28, 2023, 9:26am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594/2 "2023-09-28T09:26:58Z")
Glide arrays in general do not support included in/is included in. To use that, you would first need to create a joined list from the array. You can create relations to arrays, so maybe you should be using a relation instead of a query? ---
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [September 29, 2023, 2:24am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594/3 "2023-09-29T02:24:00Z")
You can use “contains” or “does not contain” in arrays which is effectively the same thing as using is/not included in with a joined list. ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aa0259b06b62248d409b128294f90c5fc4dbc9ae.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 29, 2023, 10:23am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594/4 "2023-09-29T10:23:27Z")
> [@james](#): > > You can use “contains” or “does not contain” ah yes, sorry - I completely forgot about that. Just getting back to your original question… > [@james](#): > > When working with a query column, I have noticed that it doesn’t seem to allow the use of an array in the filtering. I just tested that, and it seems to work as expected: ![CleanShot 2023-09-29 at 18.20.31@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4377de53116d2a30d70f5487c8b4955ed09e6b5.jpeg) Were you trying with a regular table, or a big table? If a Big Table, then that’s expected because filtering by computed columns is not supported. ---
**Author:** ![james](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/james/32/71213_2.png) [@james](https://community.glideapps.com/u/james)\ **Post date:** [October 2, 2023, 5:37am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594/5 "2023-10-02T05:37:16Z")
I’m using a regular table but a slightly different filter setup. I can’t see a way to find if the Assignee ID (i.e. Row ID) is contained in an array of this row \> Staff IDs. In the picture below you can see where I have converted it to text as a workaround. ![Capture](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/b/3b51d45c93fa571b9c1159964bb17f74ee372502.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [October 2, 2023, 5:48am UTC](https://community.glideapps.com/t/using-an-array-in-query-column-filter-by/66594/6 "2023-10-02T05:48:37Z")
Okay, I think I see what’s going on there. The problem is that AssigneeID (RowID) is not an array value, so the contains/does not contain options are not available. I think your workaround might be the only way to do it 🤷‍♂️