Prespective: Add values to dropdown from tag (Query based)

Ignition
1

Ignition_Dropdown_values Hello,

I cannot find any information on how to add values to a dropdown in Perspective using the tag (Query). This would be very helpful. I do not want to write a named query or manually add items.

Thanks,

David

2

Your dataset is 30x7

You use the options binding and have to and need data set to be Label and Value

SELECT col1 as ‘value’, col2 as ‘label’ FROM db.table;

https://docs.inductiveautomation.com/display/DOC80/Perspective+-+Dropdown

Check out the properties in the options portion of the componentdata

1 Like
3

Thank you for the quick response and the pic. It does work. Thanks. Do I need to be concerned that it looks like it has an error even though it works?

Thanks.

4

It is a known bug. Although I thought It was remedied in one of the recent builds. Make sure value and label are lowercase too.

5

I believe you could also change the Return Format to json as part of the binding, and as long as the columns are label and value, it should work.
43%20AM

6

Thanks, I did do as lowercase.