I have a checkbox variable (boolean) which I’d like to use as a filter on a Supabase query. I’m unsure how to lookup the column of a nested JSONB object in a filter as the operator available I see “is exactly” and to what the formula might look like, and if this is possible? Performance is importa…

I was really hoping the Jan 2024 big Supabase update included it as surely accessing and filtering JSON is a really common use case? * [SUPABASE] Add filters & modifiers in all query actions - was on the release notes. But it’s missing arrow operators (-> and ->> ) to access nested JSON values, sp…

I’ve had some success using the “Advanced” fileds instead of “Guided”, as this works: id, title, metadata->gender->>male Works even with the warning! [image] However this doesn’t: id, title, (metadata->'gender'->>'male')::boolean = true; I found in this helpful Supabase SDK video update from W…

After a lot of messing around i was able to crack this. I couldn’t get the “->” to work for me at all. But i found this on the superbase forum Supabase Javascript Client - Using filters (specifically the “Filter referenced tables” item) Instead of getting your nested item with table(column) t…

I have just come across an alterative solution. Create a view in superbase with the column you want to filter joined. But not apply any filters at the superbase level. The view will basically just be your the table + 1 extra column. Then in weweb create a new collection and use this new view as you…

Hello, nice solution :slight_smile: For anyone else wondering, I actually wrote an article about this. You actually should be able to use the … spread operator to get the data to the same level in the object, which then allows you to filter it. [image] Become a Supabase Magician in WeWeb (…

While the spread operator allows you to choose the field for filtering (in a collection), you can’t actually use it to filter, as weweb then tries to filter on the original collection with that column name, and gets an error. I’ve not managed to make it work at least.

First you spread the joined table via the ... spread operator, in my case I just take the brand_id for this example, I’ll filter on it. [Screenshot 2024-08-08 at 17.01.58] Then you set up the filter on the brand_id to be equal to 132 [Screenshot 2024-08-08 at 17.01.10]

Does brand_id exist in the products table by any chance, maybe thats the foreign key? Try to put a filer on brand_name? [image] [image]

Yeah now I see it, you’re right. The issue is that WeWeb parses it as a direct column as you said. With the Workflow Actions it works though. You just need to do the [table].column instead of the column directly. Nice catch. I already raised this issue of filtering being different for collections wi…

How to filter through a nested JSON object in Supbase?

Ask us anything

sam1 (sam) April 8, 2024, 11:00pm 2

I’m looking for pretty much the same thing I found this post so I’m assuming it needs to be done through an endpoint still.

Topic		Replies	Views
WeWeb Supabase bug with "JSON" type columns Ask us anything supabase	5	380	October 17, 2023
How would you filter a JOIN query in Supabase Plugin? How do I? supabase	24	1317	April 29, 2026
Filter with inner join in supabase How do I? supabase	3	266	October 6, 2024
How to handle Supabase collection fetches w/ foreign key filters? How do I? supabase	17	897	July 22, 2024
Filter on comparison between fields How do I? filter , supabase	3	242	March 21, 2024

How to filter through a nested JSON object in Supbase?

Related topics