Do I understand correctly Data Explorer does not support Json Extracts?
I tried, it returns the error:
PG::UndefinedFunction: ERROR: function json_extract(text, unknown) does not exist
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
That is a MySQL function, but Data Explorer queries Discourse’s PostgreSQL database instead.
Based on this SO answer, you’re looking for Postgres’
@> operator for JSON data types:
Thank you! It was actually more like json_extract_path_text and helped construct a nice query for Falco’s Disorder here