Skip to content

Instantly share code, notes, and snippets.

@leylaKapi
Created October 31, 2017 07:04
Show Gist options
  • Save leylaKapi/ea1a55a65a77b663d236a3e2191fa4fa to your computer and use it in GitHub Desktop.
Save leylaKapi/ea1a55a65a77b663d236a3e2191fa4fa to your computer and use it in GitHub Desktop.
Rails pg jsonb column search method
# heading jsonb cloumn, and title a field inside jsonb search in jsonb
# heading: { title: "ABC" }
# For detail look at http://edgeguides.rubyonrails.org/active_record_postgresql.html#json-and-jsonb
def self.search(search)
q = "%#{search.downcase}%"
where("lower(heading ->> 'title') LIKE ?", q)
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment