ActiveRecord & Postgresql: Query jsonb attribute

Question

I have a model Characteristic, with a equivalent attribute which is a jsonb value.

ex:

characteristic1: 
id:1
equivalent: {list: ['first', 'second', 'third']}

characteristic2: 
id:2
equivalent: {list: ['fourth', 'fifth', 'sixth']}

How can I find the record with second in the list using active record query interface?

Graham Slick · Accepted Answer · 2017-02-16 11:48:11Z

1

Found a way:

Characteristic.where("equivalent -> 'list' ? 'second' ")

answered Feb 16, 2017 at 11:48

Graham Slick

6,84411 gold badges56 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1