Does the data explorer support json extracts?

Data & reporting
1

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.

2

Hi!

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:

4 Likes
3

Thank you! It was actually more like json_extract_path_text and helped construct a nice query for Falco’s Disorder here

4 Likes