Query on a json (not structure object) field won't work

Trying to query on a json (not structure object) field but it won't work using dot notation.

Example: table1 with json field settings and key happy:true. Query all on table1.settings.happy == true returns nothing. The same thing with a structured object field works fine.

The query's output is paginated, so prefer to do it all in the query if possible.

TIA!

3 replies