You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Via regular queries directly in my PostgreSQL shell like SELECT * FROM sales_order WHERE sales_order_data->'entity'->'billing_address'->'last_name' ? 'foobar';
I am able to retrive data (I know that this would be closer to JSONB_EXISTS).
But I seem to be unable to replicate the same behavior via Doctrine QueryBuilder and this extension.
Funnily enough I am able to access the "identifier" field with
but I couldn't for example get billing_address and last_name below it which is why I have the feeling, that this library can only go down one layer into JSON data.
Is that the case?
The text was updated successfully, but these errors were encountered:
This library just allows you to use the SQL functions. It only unlocks the json functions and allows you to use them within Doctrine (with Doctrine Query Language).
Like the title says, can you use JSON_GET on JSONB columns deeper than one layer for PostgreSQL databases?
I have a table called sales_order that contains a JSONB column called sales_order_data. This column contains json roughly in the shape of:
Via regular queries directly in my PostgreSQL shell like
SELECT * FROM sales_order WHERE sales_order_data->'entity'->'billing_address'->'last_name' ? 'foobar';
I am able to retrive data (I know that this would be closer to JSONB_EXISTS).
But I seem to be unable to replicate the same behavior via Doctrine QueryBuilder and this extension.
Funnily enough I am able to access the "identifier" field with
but I couldn't for example get
billing_address
andlast_name
below it which is why I have the feeling, that this library can only go down one layer into JSON data.Is that the case?
The text was updated successfully, but these errors were encountered: