# How to add a row to a dropdown?

**URL:** <https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343>\
**Category:** Ignition\
**Created:** [November 22, 2021, 2:20pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343 "2021-11-22T14:20:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 22, 2021, 2:20pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343/1 "2021-11-22T14:20:12Z")

</div>

Hello All,

I have a dropdown menu and its data is bound to a named query, now I want to manually add another row to this drop-down, but I can not find any solution for it. Manual suggested using a push-button and use **system.dataset.addRow(dataset [, rowIndex], row)** but I do not want to do that. Is it possible to add the row inside the named query? The new row is not coming from another database table.

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [November 22, 2021, 2:26pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343/2 "2021-11-22T14:26:26Z")

</div>

Will it always be the same row that is being added? If so adding it into the named query is a good option.

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 22, 2021, 2:27pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343/3 "2021-11-22T14:27:31Z")

</div>

Yes, I just want to add the row permenantly. I have read somewhere we can use Union All statements, I am looking into that to see how I can implement it.

---

<div class="post-metadata">

**Author:** ![JoeF](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@JoeF](https://forum.inductiveautomation.com/u/JoeF)\
**Post date:** [November 22, 2021, 2:29pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343/4 "2021-11-22T14:29:22Z")

</div>

UNION would work:

```auto
SELECT value_column, label_column FROM my_sql_table
UNION
SELECT 'additional_value', 'additional_label'

```

---

<div class="post-metadata">

**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\
**Post date:** [November 22, 2021, 2:32pm UTC](https://forum.inductiveautomation.com/t/how-to-add-a-row-to-a-dropdown/53343/5 "2021-11-22T14:32:17Z")

</div>

> [@JoeF](#):
>
> ```auto
> SELECT value_column, label_column FROM my_sql_table
> UNION
> SELECT 'additional_value', 'additional_label'
> 
> ```

Thank you very much, Joe! That worked actually. Appreciate it.