Populate Perspective Dropdown with Named Query

[Alejandro_Alaco]

Hello,

I would like to populate a dropdown with the content from a Named Querie, but is not showing, probably because the Named Queries has multiple columns...?

SELECT EquipmentType, EquipmentTypeName AS data1  
FROM EquipmentType 
WHERE COMPANY = 'COMPANYNAME' 
AND EquipmentType NOT IN ('ATE', 'CLC', 'CLT') 
ORDER BY EquipmentTypeName ASC

[cmallonee]

A very quick search of "dropdown named query" provided the following thread:

Dropdown Options

Lets say I have a dropdown - the options are bound to a named query that returns 3 columns. I have columns ID, x, y. Is there a way to have x,y show up on each option together?

As part of that thread, there's a very clear example of how to achieve this. Please search for existing answers before requesting assistance.

[Alejandro_Alaco]

I had to bind the dataset to props.options so i can see the dropdown populated with that content.