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