Check for empty hash inside where clause in rails

Question

I want to get all books that have nil empty string or empty hash on a property

Book.where(references: [nil, "", {}])

This gives me an error.

ERROR: invalid input syntax for type json LINE 1: ...on_id" = $1 AND ("books"."references" IN ('', '{}') ... ^ DETAIL: The input string ended unexpectedly. CONTEXT: JSON data, line 1:

references is a json field on a postgres database

What is the error? Put the trace please. – Jose Manuel Apr 10 '19 at 12:47 — Jose Manuel, Apr 10 '19 at 12:47
Can you add more code? What’s building this array? – Nate Apr 10 '19 at 12:52 — Nate, Apr 10 '19 at 12:52

score 2 · Answer 1 · edited Apr 10 '19 at 14:00

2

I have found here How to query a json column for empty objects?

Book.where(references: [nil, ""]).where("references::text = '{}'::text")

edited Apr 10 '19 at 14:00

Jose Manuel

183
7

answered Apr 10 '19 at 13:06

Petran

7,677
22
65
104

Check for empty hash inside where clause in rails

1 Answers1