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: [이미지] 9.16. JSON Functions and Operators 9.16. JSON Functions and Operators # 9.16.1. Processing and …

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

데이터 탐색기에서 JSON 추출을 지원하나요?

커뮤니티 구축 데이터 및 보고

kinetiksoft 3월 1, 2023, 12:46오후 3

감사합니다! 실제로는 json_extract_path_text가 더 적절했으며, Falco’s Disorder here를 위한 좋은 쿼리를 구성하는 데 도움이 되었습니다.

글		댓글	조회수
Missing query plans in Data Explorer Bug data-explorer	2	167	4월 23, 2025
Error exporting CSV or JSON from Data Explorer plugin Product Support data-explorer	7	563	3월 9, 2024
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	86402	10월 22, 2025
External Data Analysis Product Support	2	1799	7월 6, 2018
Can I create a new query in Data Explorer using API? Development data-explorer , rest-api	2	729	1월 26, 2026

데이터 탐색기에서 JSON 추출을 지원하나요?

Related topics