Breaking News: Grepper is joining You.com. Read the official announcement!

search a field in a json rails

Testy Termite answered on August 19, 2022 Popularity 3/10 Helpfulness 2/10

answer search a field in a json rails

search a field in a json rails

Comment

# Given a Task model with 'details' json column
Task.where("details->>'key' = ?", "value") # matches where 'details' contains "key":"value"
Task.where("details->>'{a,b}' = ?", "value") # matches where 'details' contains "a":{"b":"value"}
Task.where("details->'a'->>'b' = ?", "value") # same as above, but via operator chaining

Popularity 3/10 Helpfulness 2/10 Language ruby

Source: Grepper

Tags: field json ruby search

Link to this answer
Share Copy Link

Contributed on Aug 19 2022

Testy Termite

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

search a field in a json rails

Contents

More Related Answers

search a field in a json rails

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.