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 추출을 지원하나요?

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

leonardo (Leonardo Mosquera) 3월 1, 2023, 12:28오후 2

안녕하세요!

이것은 MySQL 함수이지만, Data Explorer는 Discourse의 PostgreSQL 데이터베이스를 쿼리합니다.

이 SO 답변에 따르면, JSON 데이터 유형에 사용할 Postgres의 @> 연산자를 찾으시는 것입니다:

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

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

Related topics