# Dropdown node does not show query result when it is a array\[1\]

**URL:** <https://discourse.nodered.org/t/dropdown-node-does-not-show-query-result-when-it-is-a-array-1/60325>\
**Category:** General\
**Created:** [25 March 2022 09:02 UTC](https://discourse.nodered.org/t/dropdown-node-does-not-show-query-result-when-it-is-a-array-1/60325 "2022-03-25T09:02:18Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [25 March 2022 09:29 UTC](https://discourse.nodered.org/t/dropdown-node-does-not-show-query-result-when-it-is-a-array-1/60325/4 "2022-03-25T09:29:06Z")

</div>

I followed this link

> [@UI Dropdown - get result from SQL](https://discourse.nodered.org/t/ui-dropdown-get-result-from-sql/614):
>
> Have some data from a MSSQL node that I want to insert as values in a Dropdown node, so I can return the selected value. But have searched high and low, but have not found and examble I can use Data… [{“Name”:“Name1”},{“Name”:“Name2”},{“Name”:“Name3”},{“Name”:“Name4”},{“Name”:“Name5”},{“Name”:“Name6”},{“Name”:“Name7”},{“Name”:“Name8”}]

---

_[View the full topic](https://discourse.nodered.org/t/dropdown-node-does-not-show-query-result-when-it-is-a-array-1/60325)._