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?

[image] 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?

Using Parameters in Data Explorer Queries

Community Building Data & reporting

zogstrip December 13, 2025, 10:33am 6

PSA: this was added recently by

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

Requirements for Trust Level 3

Topic		Replies	Views
`DataExplorer::ValidationError: Missing parameter` when running Data Explorer queries with [params] via API Data & reporting rest-api , sql-query	9	1181	May 10, 2022
Param dropdown for group_id in data explorer query Feature data-explorer , completed	17	1196	June 5, 2025
Discourse Data Explorer SQL Query Support data-explorer	4	107	April 14, 2025
How to add query parameters to Data Explorer? Development	7	1072	November 25, 2020
Is it possible to give an alias to a query parameter? Support data-explorer	9	899	August 26, 2023

Using Parameters in Data Explorer Queries

Related topics