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?

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

Parameters gebruiken in Data Explorer-query's

Gemeenschap Gegevens en rapportage

zogstrip 13 december 2025 om 10:33 6

PSA: this was added recently by

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

Requirements for Trust Level 3

Topic		Antwoorden	Weergaven
`DataExplorer::ValidationError: Missing parameter` when running Data Explorer queries with [params] via API Data & reporting rest-api , sql-query	8	1198	10 april 2022
Param dropdown for group_id in data explorer query Feature data-explorer , completed	17	1220	5 juni 2025
Discourse Data Explorer SQL Query Support data-explorer	3	114	15 maart 2025
How to add query parameters to Data Explorer? Development	7	1078	25 november 2020
Is it possible to give an alias to a query parameter? Support data-explorer	9	913	26 augustus 2023

Parameters gebruiken in Data Explorer-query's

Gerelateerde topics