# Perspective Dropdown SQL Query - No results found

**URL:** <https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query-no-results-found/43123>\
**Category:** Ignition\
**Tags:** perspective, database\
**Created:** [February 8, 2021, 8:51am UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query-no-results-found/43123 "2021-02-08T08:51:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![OscarLucas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/oscarlucas/32/6417_2.png) [@OscarLucas](https://forum.inductiveautomation.com/u/OscarLucas)\
**Post date:** [February 8, 2021, 8:51am UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query-no-results-found/43123/1 "2021-02-08T08:51:55Z")

</div>

Dear all, i’m new in this of perspective. I am just adding a drop down and blinking to a database id column.  
I can´t make it work.  
I use the same query in the table and into the dropdown list.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/0/e0c34a3ab4f37b36e7add7ac02dd8c860812b8ca.png)  
The table shows the data. but the dropdown seems to be empty. HAve i to to do any other conf for the dropdown?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/d/0d44238c20f84add7d3d3b75e036ccb1e92fe946.png)

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [February 8, 2021, 9:10am UTC](https://forum.inductiveautomation.com/t/perspective-dropdown-sql-query-no-results-found/43123/2 "2021-02-08T09:10:55Z")

</div>

You bound the _value_ property rather than the _options_