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!