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:
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.
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.
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
@Craig did you find a solution for this?
What about running this filter from the backend in Xano?
Hey everyone,
Will there be such functionality in the future? Would appreciate it.
@Craig Question 2
Thanks a lot
Hi. Please can I ask if there is there any update to this? I’ve got the same 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.
Following up as well on this topic
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.
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), … ?
I’ve managed to achieve this in Supabase using Database | Select and filters, as opposed to on the “collection” which is also possible.
metadata->gender->>male
With “metadata” being the column name.
Davy Apr 11:
Top, works for me in this way!
Many thanks to you!
Stefan
