Query builder doesn't recognise objects as column type

[JonL]

I am having to switch to custom queries as I can’t query json columns.

Database query builder:

Database manager does identify them correctly as you can see below:

Options I can think of:

1. Make the builder identify json columns and let us pick the key. Probably complicated as json schemas are unknown.

2. Let us edit the Column contents so we can add the query to the key and be processed correctly by SC database module.
   title -> key as title_value

Reference: https://www.postgresql.org/docs/12/functions-json.html

[George]

As for the Database Manager, we could allow to define the extra schema for the json field.

However i’m not sure how the database updates and inserts will have to handle updating the json fields … @patrick?

[JonL]

@George

As for the Database Manager, we could allow to define the extra schema for the json field.

That would be cool.

[mgaussie]

@JonL did you end up just sticking with custom queries for json/jsonb columns here? Introducing a Postgres dB as we speak specifically for json use cases so searching the forum at the moment for others that are working with this.

[JonL]

Yup. Custom queries.

[JonL]

I believe this was sort of added right @George? With one of those UI improvements nobody notices. In case you want to close. I’m doing some clean up on my bug reports.