# Accessing nested object to filter Collections **URL:** \ **Category:** Ask us anything\ **Tags:** binding, filter\ **Created:** [July 19, 2023, 6:52pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600 "2023-07-19T18:52:58Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Amos](https://avatars.discourse-cdn.com/v4/letter/a/ebca7d/32.png) [@Amos](https://community.weweb.io/u/Amos)\ **Post date:** [July 19, 2023, 6:52pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/1 "2023-07-19T18:52:58Z")
Hello, I’m looking to filter a Collection (Plaid transaction data). I have a category array that is nested in the a Properties object, returned by the Plaid API to my Xano DB. Here’s what the data structure looks like in WeWeb: ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/7/75a3854cee66c0767c881eba873fbb0d8d5e08d6.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/0/043b42acfe935085d8c89f3f4ffbb4c449187aa1.png) For some reason, I’m unable to access the Category array to apply a filter (see below). Any idea how to work around this, or if this is functioning as intended? Goal is to filter transactions based on category. ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/8/83991c7a2d32cf58379fab2bd4db4837d6df6c99.png) ---
**Author:** ![Quentin](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/quentin/32/6_2.png) [@Quentin](https://community.weweb.io/u/Quentin)\ **Post date:** [July 24, 2023, 9:15am UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/2 "2023-07-24T09:15:44Z")
It’s currently not possible at the collection level, but we’re working on this. You could use a frontend filter though, or try to create an endpoint on your backend that would return the filtered list only. ---
**Author:** ![Craig](https://avatars.discourse-cdn.com/v4/letter/c/ed8c4c/32.png) [@Craig](https://community.weweb.io/u/Craig)\ **Post date:** [December 4, 2023, 4:28pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/3 "2023-12-04T16:28:30Z")
Hi folks, any update on the nested filters functionality? I am also running into this with my app, whereby i need to do a dynamic filter based on the users selections. My schema is similar to Amos’ above. I have “Locations”, and each location can have multiple “programs”. Programs are the nested object on my collection. My users filter on variables on both the locations data (city, location name) and program data (type, price etc.) i am unable to filter on the nested program data. Question 1: any sense of when this would be expected? Question 2: if not shipping imminently, what are other front end (weweb) or backend (im using xano in this case) workarounds? Thank you! greatly appreciate any guidance from the community here ---
**Author:** ![vic](https://avatars.discourse-cdn.com/v4/letter/v/9e8a1a/32.png) [@vic](https://community.weweb.io/u/vic)\ **Post date:** [January 25, 2024, 9:59pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/4 "2024-01-25T21:59:06Z")
@Craig did you find a solution for this? ---
**Author:** ![Profound5753](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/profound5753/32/6870_2.png) [@Profound5753](https://community.weweb.io/u/Profound5753)\ **Post date:** [January 26, 2024, 4:28am UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/5 "2024-01-26T04:28:49Z")
What about running this filter from the backend in Xano? ---
**Author:** ![Tim](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/tim/32/6425_2.png) [@Tim](https://community.weweb.io/u/Tim)\ **Post date:** [March 13, 2024, 12:07pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/6 "2024-03-13T12:07:56Z")
Hey everyone, Will there be such functionality in the future? Would appreciate it. @Craig Question 2 Thanks a lot ---
**Author:** ![what.gift](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/what.gift/32/8069_2.png) [@what.gift](https://community.weweb.io/u/what.gift)\ **Post date:** [April 9, 2024, 8:52am UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/7 "2024-04-09T08:52:32Z")
Hi. Please can I ask if there is there any update to this? I’ve got the [same](https://community.weweb.io/t/how-to-filter-through-a-nested-json-object-in-supbase/7969) requirement and I need to access the nested JSON from a column that’s stored in Supabase. In my case, the ecommerce style category page has a lot of filters relying on metadata to be searched through. ---
**Author:** ![Davy](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@Davy](https://community.weweb.io/u/Davy)\ **Post date:** [April 10, 2024, 3:22pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/8 "2024-04-10T15:22:58Z")
Following up as well on this topic ---
**Author:** ![Davy](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@Davy](https://community.weweb.io/u/Davy)\ **Post date:** [April 11, 2024, 8:31am UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/9 "2024-04-11T08:31:03Z")
Quick update, for those using xano as a backend with nested objects, here is what I have been able to do. My initial file had an add-on to retrieve more values. Instead, I joined the files (there is a specific join feature function when making a query request). Then in “eval” (outcome), I have been able to create a new field and select the value I needed. When connected to Weweb, I have been able to access it in the filer where I could not before. Probably not the best option but it worked. Ps : in case you have duplicates in your xano response, add a condition where. “Field from database 1 (ex: ID)” = (Field from database 2 (ex: user\_id, the field matching the value of the field from database 1). Hope that temporary helps. ---
**Author:** ![arturosanz](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/arturosanz/32/4595_2.png) [@arturosanz](https://community.weweb.io/u/arturosanz)\ **Post date:** [April 14, 2024, 10:48pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/10 "2024-04-14T22:48:00Z")
Does anyone know when it’s going to be possible to filter by an object property? Another question related to this. What is the use for WHERE {object} CONTAINS? What it is supposed to look for inside the object? Keys, values, both (and/or), … ? ---
**Author:** ![what.gift](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/what.gift/32/8069_2.png) [@what.gift](https://community.weweb.io/u/what.gift)\ **Post date:** [April 15, 2024, 3:45pm UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/11 "2024-04-15T15:45:18Z")
I’ve managed to achieve this in Supabase using **Database | Select** and filters, as opposed to on the “collection” which is also possible. ```auto metadata->gender->>male ``` With “metadata” being the column name. ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/4/4286e990da1d59b1f0df8f0297a42a4f7759bd37.png) s ---
**Author:** ![StefanSan](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@StefanSan](https://community.weweb.io/u/StefanSan)\ **Post date:** [June 8, 2024, 11:52am UTC](https://community.weweb.io/t/accessing-nested-object-to-filter-collections/3600/12 "2024-06-08T11:52:50Z")
Davy Apr 11: Top, works for me in this way! Many thanks to you! Stefan