How do I make queries on json object type fields?

How do I make queries on json object type fields?

When I use ‘IN’ operator it doesn’t work

1 Like

Database schema type must be JsonB, not Json

Don’t know if that’s the solution to your problem, but you need JsonB for the SQL server to parse the JSON, otherwise it’s stored as raw text

1 Like