Parameters are a powerful tool that can be used in Data Explorer queries on Discourse. Parameters allow for more dynamic and customizable queries, and instead of hard-coding values in your queries, you can declare variables that will prompt for input when the query is run. Declaring a Parameter T…

These are great guides, thank you for posting them @SaraDev :slight_smile: :hugs:

@AlexDev can a field name in where clause be a parameter ? thanks or the whole sql statement be a parameter to pass in from the rest endpoint /admin/plugin/explorer/queries/id/run

PSA: You can not use numbers in your parameter names, e.g. “foo123” will fail. -- [params] -- string :foo123 = a SELECT :foo123 results in PG::SyntaxError: ERROR: syntax error at or near ":" LINE 10: SELECT :foo123 ^

I tried to POST call the run endpoint with parameters in the json payload as payload = { "params": { "request_post_id": "45" }, "explain": False } I reverse angineered the payload from chrome dev tab payload Somehow I keep getting 500 server error Can someone please help me?

[이미지] SaraDev: Internal Parameters current_user_id: No input UI; automatically sets the variable to the user ID of the user running the query PSA: this was added recently by https://github.com/discourse/discourse/pull/36655

Feature request: Would it be possible to add tag_group as a parameter type which would inject the integer ID of the selected tag group?

데이터 탐색기 쿼리에 매개 변수 사용

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

zogstrip 12월 13, 2025, 10:33오전 6

PSA: this was added recently by

https://github.com/discourse/discourse/pull/36655

Requirements for Trust Level 3

글		댓글	조회수
`DataExplorer::ValidationError: Missing parameter` when running Data Explorer queries with [params] via API Data & reporting rest-api , sql-query	8	1264	4월 10, 2022
Param dropdown for group_id in data explorer query Feature data-explorer , completed	17	1306	6월 5, 2025
Discourse Data Explorer SQL Query Support data-explorer	3	143	3월 15, 2025
How to add query parameters to Data Explorer? Development	7	1120	11월 25, 2020
Is it possible to give an alias to a query parameter? Support data-explorer	9	951	8월 26, 2023

데이터 탐색기 쿼리에 매개 변수 사용

Related topics