Dropdown component shows values, not labels

Ignition
, ,
1

Hi,
I have a dropdown component which has a query as the binding type. The return format is set to auto.
This is my named query:

SELECT  0, '<Select One>'
UNION
SELECT IssueId, IssueName FROM vwIssueToPrint

This query is working well, I can see that it creates a table 6x2. Everything seems to be fine. But the problem is that the dropdown is not showing the labels, which are in the column 2, but it's showing the values in the column 1.
I have this same project in vision, using this same query, and there it works fine. But in perspective I have this issue.
What could be the reason for this?
Thanks.

2

Perspective doesn't use two columns. I recommend you bind that dataset to custom property (to maintain correspondance between IssueId and IssueName), then bind the dropdown's options to the dataset property with a transform that delivers just the names.

Or possibly just reverse the column order.

3

Try something like the below, cant test it as I don't have your DB but works in my project (with my table names)

Select '0' as 'value', '<Select One>' as 'label'
Union All
SELECT IssueId as 'value', IssueName as 'label'
FROM vwIssueToPrint
ORDER BY label

Edited to say you will need to change the ORDER BY to ORDER BY label I corrected the above.

4

Thank you for your answers.
This script really works:

Select '0' as 'value', '<Select One>' as 'label'
Union All
SELECT IssueId as 'value', IssueName as 'label' FROM vwIssueToPrint
ORDER BY label

Thanks again.