JSON data filters with Supabase
Hi everyone ! I have filter problems with JSON data with supabase . I 'm trying to push supabase a little further than a simple table but I 'm finding myself having difficulty . My API call without filter returns me the data . But as soon as I want to make a filter on the JSON "collections " , impossible . I have a status code 200 but an empty response . "products _collections _variants ?select =title ,collections &collections - > >slug =eq .incontinence " Can anyone guide me ? Thank you ! I see two things . 1 . You need to put the query separately from the select . Something like this products_collections_variants?and=(collections->>slug.eq.incontinence)&select=* 2 . You have an array in your collections field so if that is expected you need to target a particular item /index in the json path . Now for the plug - I figured this out by building a query visually in Comnoco and then seeing what it constructed by looking at the debug logs . It 's a backend visual language so it allows you to build visual logic , APIs , scheduled tasks etc and connect to any database . Like Xano but made to work with any database and auth . You don 't need a backend to do simple CRUD calls to Supabase protected by RLS , Comnoco is for backend logic - like a visual way to build logic and secure API connectivity instead of edge functions . Hey @saillmone ! I wish I discovered Comnoco sooner , it 's definitely worth checking out especially if you 're coming from Toddle . There are many similarities , and the trifecta of Toddle , Comnoco , and Supabase is ππΌ . Would be happy to connect and share insights on this if you decide to use it π₯1β€οΈ1
