aleksb86/jsonb_quering.rb

Last active August 11, 2020 09:48

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/aleksb86/538f19c2ec0518420d515f829efca8cf.js"></script>
Save aleksb86/538f19c2ec0518420d515f829efca8cf to your computer and use it in GitHub Desktop.

Download ZIP

Quering with Active Record json fields (PostgreSQL)

Raw

jsonb_quering.rb

	Orchestrator::Models::Order.where("params ->> 'parent_order_id' = :id", id: '2403')

	VmOrder.where("params -> 'os' ? :os", os: 'RHEL 7.6 x64').first

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment