How to have duplicate values ( '__value') in same variable?

  • What Grafana version and what operating system are you using?
    v8.0.1, Ubuntu

  • What are you trying to achieve?
    Have a variable with duplicate values.

Hi everyone,

I have a variable with the following query:

SELECT postcode_label AS “__text”, postcode_id AS “__value”
FROM postcodes

In my ‘postcodes’ table I have multiple records with the same postcode_id. The problem is that in my populated dropdown, only the first record (from records with same postcode_id) is shown. Any other duplicate is ignored.

Any ideas how to overcome this problem? Thanks in advance!