Help with query via the client API

I'm trying to convert this PostgreSQL query to PostgREST or the client API, but cannot find any good resources on nested WHERE constraints for example.

SELECT *
FROM records AS r
JOIN cells AS c ON r.id = c."recordId"
WHERE 
      (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%Ams%')
  AND (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%TH%')
;

SELECT *
FROM records AS r
JOIN cells AS c ON r.id = c."recordId"
WHERE 
      (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%Ams%')
  AND (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%TH%')
;

I want the above to be converted to client API.

Supabase•3y ago•

2 replies

guidsen

Help with query via the client API

I'm trying to convert this PostgreSQL query to PostgREST or the client API, but cannot find any good resources on nested WHERE constraints for example.

SELECT *
FROM records AS r
JOIN cells AS c ON r.id = c."recordId"
WHERE 
      (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%Ams%')
  AND (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%TH%')
;

SELECT *
FROM records AS r
JOIN cells AS c ON r.id = c."recordId"
WHERE 
      (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%Ams%')
  AND (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%TH%')
;

I want the above to be converted to client API.

Help with query via the client API

Similar Threads

Help with query via the client API

Similar Threads

Similar Threads

Similar Threads