Query parameters are great for obvious reasons. When you make Data Explorer queries available to less-than-technical users though, they can sometimes be confused by the name (even if it’s just a variable name with an underscore). Can you give an alias to a query parameter so it shows up with a nice…

Hi @jordan-violet :wave: I think perhaps one can do something like this - Is this what you mean? SELECT column_name AS alias_name FROM table_name; ... or like SELECT column_name(s) FROM table_name AS alias_name ....

No sorry, the input parameters to the query. Like so: [image]

ooh sorry I misunderstood your question! hmmm :thinking:

Yep, I have that now, but it’s just not as polished when you’re trying to make these reports friendly to very non-technical people in places like sales, marketing, etc. In fact, it’d be nice if it went one step further and also gave you the option of defining a tooltip/info icon description as well…

[изображение] Jordan Violet: it’s just not as polished when you’re trying to make these reports friendly to very non-technical people DE is very raw… building a different UI (be it a webpage or a spreadsheet or an application) is probably a good idea. A great example is Grafana! Grafana has…

Yeah, we run Tableau in our business and we do export all Discourse data so it can be used there. But I do enjoy bringing users, including internally, into the platform. I always attempt to champion for less tools as much as possible and avoid too much sprawl.

FWIW, I really like this idea. I think having a ‘friendly label/placeholder’ would be a good addition. I am not sure how to achieve it though. :thinking:

So many options! One of the more simple solutions would be to check for an optional label variable in the current format you all use, e.g.: -- [params] -- text :user_group -- label: "The Salesforce account name for the customer you want to look up in this query." -- text :topic_id Admittedly I ha…

Is it possible to give an alias to a query parameter?

Поддержка

Lilly 26.Август.2023 01:55:48 6

I believe you can edit the query in Data Explorer and add a description about how the param should be set. It will show up when the report is run:

1 лайк

Тема		Ответов	Просм.
How to add query parameters to Data Explorer? Development	7	1040	25.11.2020
Using Parameters in Data Explorer Queries Data & reporting sql-tutorial , data-explorer	6	1622	10.02.2026
Param dropdown for group_id in data explorer query Feature data-explorer , completed	17	1146	05.06.2025
Populate Data Explorer params with URL params Feature data-explorer , completed	13	1518	03.09.2025
Discourse Data Explorer Plugin official , data-explorer , included-in-core	31	82242	22.10.2025

Is it possible to give an alias to a query parameter?

Связанные темы