# Table column dropdown embed with sql

**URL:** <https://forum.inductiveautomation.com/t/table-column-dropdown-embed-with-sql/115372>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [May 4, 2026, 10:53pm UTC](https://forum.inductiveautomation.com/t/table-column-dropdown-embed-with-sql/115372 "2026-05-04T22:53:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![uy\_huynh](https://avatars.discourse-cdn.com/v4/letter/u/54ee81/32.png) [@uy\_huynh](https://forum.inductiveautomation.com/u/uy_huynh)\
**Post date:** [May 4, 2026, 10:53pm UTC](https://forum.inductiveautomation.com/t/table-column-dropdown-embed-with-sql/115372/1 "2026-05-04T22:53:27Z")

</div>

Hi all,

Having some issue with displaying the default value of drop down.

I have the dropdown below:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/4/f43290171ddf9c931ee6184cd7429a4196cd12a9.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/9620ae04337bf32143a0d336794f3738baf47d09.png)

And I have a table with coumn 3 as MACHINESTAUS from a sql view:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/940d518ce82cde369e09291c5e085c6806001b55.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/e/6e6b00edc9089911ca83e3b531ce1ed44d2b3fb5.png)

Right now, I can update the data of the SQL table TUFT\_PRODUCT\_PRIORITY. The only problem is that whenever I reload my session, the dropdown returns to "Select". How do I configure these dropdowns to display the MACHINESTATUS from TUFT\_PRODUCT\_PRIORITY\_V?

I appreciate all the help.

---

<div class="post-metadata">

**Author:** ![JVDM](https://avatars.discourse-cdn.com/v4/letter/j/ac8455/32.png) [@JVDM](https://forum.inductiveautomation.com/u/JVDM)\
**Post date:** [May 5, 2026, 8:40am UTC](https://forum.inductiveautomation.com/t/table-column-dropdown-embed-with-sql/115372/2 "2026-05-05T08:40:39Z")

</div>

Take a look at this thread, that had a similar issue:

[Perspective dropdown How to Default to the First Value? - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/perspective-dropdown-how-to-default-to-the-first-value/75285)