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?

שימוש בפרמטרים בשאילתות Data Explorer

קהילה נתונים ודיווח

zogstrip 13 בדצמבר,‏ 2025,‏ 10:33am 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	1188	10 באפריל,‏ 2022
Param dropdown for group_id in data explorer query Feature data-explorer , completed	17	1201	5 ביוני,‏ 2025
Discourse Data Explorer SQL Query Support data-explorer	3	107	15 במרץ,‏ 2025
How to add query parameters to Data Explorer? Development	7	1076	25 בנובמבר,‏ 2020
Is it possible to give an alias to a query parameter? Support data-explorer	9	909	26 באוגוסט,‏ 2023

שימוש בפרמטרים בשאילתות Data Explorer

נושאים קשורים