Combine values of Query variable with some hard coded values

  • What Grafana version and what operating system are you using?
    8.3.x on Linux

  • What are you trying to achieve?
    I retrieve a list of tags from influxdb to fill a query variable, and I want to add a hardcoded value to the results

  • How are you trying to achieve it?
    writing a query that retrieves the tags from influxdb and unioning it with the hard coded values

  • What happened?
    an error is displayed and the query variable results are empty

  • What did you expect to happen?
    Retrieve a list of tags with the hard-coded values appended

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    I’m trying to copy them, but they dissappear as soon as the mouse hovers over them. See attached screen shot.

  • Did you follow any online instructions? If so, what is the URL?
    No

Maybe what I’m trying is not the right approach to what I want, but is there a way to achieve this:
desired result:

  • hardcode value
  • value 1 from influxdb
  • value 2 from influxdb

What I have now is the list above without the hard coded value at the top.

Perhaps I can create a Custom variable with the hard-coded value and append the result of the query to it?
Or is this a use case for a scripted dashboard maybe?