# Populate Perspective Dropdown with Named Query

**URL:** <https://forum.inductiveautomation.com/t/populate-perspective-dropdown-with-named-query/89634>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [April 29, 2024, 2:31pm UTC](https://forum.inductiveautomation.com/t/populate-perspective-dropdown-with-named-query/89634 "2024-04-29T14:31:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [April 29, 2024, 2:31pm UTC](https://forum.inductiveautomation.com/t/populate-perspective-dropdown-with-named-query/89634/1 "2024-04-29T14:31:30Z")

</div>

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...?

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

```

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/b/bb149b1c8b3227aed3fb2c1ea5438153c7370a0f.png)

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [April 29, 2024, 2:35pm UTC](https://forum.inductiveautomation.com/t/populate-perspective-dropdown-with-named-query/89634/2 "2024-04-29T14:35:49Z")

</div>

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

> [@Dropdown Options](https://forum.inductiveautomation.com/t/dropdown-options/83577):
>
> 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.

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [May 8, 2024, 2:02pm UTC](https://forum.inductiveautomation.com/t/populate-perspective-dropdown-with-named-query/89634/3 "2024-05-08T14:02:32Z")

</div>

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