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.

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: [Bild] 9.16. JSON Functions and Operators 9.16. JSON Functions and Operators 9.16.1. Processing and C…

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

Unterstützt der Daten-Explorer JSON-Extrakte?

Gemeinschaft Daten & Berichterstattung

kinetiksoft 1. März 2023 um 12:46 3

Danke! Es war eigentlich eher wie json_extract_path_text und half beim Erstellen einer schönen Abfrage für Falcos Disorder hier

Thema		Antworten	Aufrufe
Missing query plans in Data Explorer Bug data-explorer	3	92	22. Mai 2025
Error exporting CSV or JSON from Data Explorer plugin Support data-explorer	8	437	8. April 2024
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82461	22. Oktober 2025
External Data Analysis Support	3	1701	29. Januar 2021
Can I create a new query in Data Explorer using API? Development data-explorer , rest-api	2	620	26. Januar 2026

Unterstützt der Daten-Explorer JSON-Extrakte?

Verwandte Themen