Hi everyone, ich want to use the ui_dropdown Node to make a selection of some sensors. The id's and names are stored in a mysql database. I used the thread from @knolleary ( UI Dropdown - get result from SQL ) to change my Data in the needed form. [grafik] The debug node gives the following answer: …

I got it. Thank you very much. The difference was, that I have to change the numbers into a string. No it works fine. [grafik] It has to look like this.

zenofmud 27 February 2020 11:13 2

If you provide an export of the flow it will be easier to see what is happening.

Topic		Replies	Views
Mysql database in dropdown node Dashboard	31	4295	22 May 2019
UI Dropdown - get result from SQL Dashboard	50	18841	12 November 2018
UI Dropdown - Populating Data General	28	20483	30 July 2021
Setting Dropdown in input text node Dashboard node-red-dashboard	3	172	12 January 2024
Populate data from database into Dropdownlist General	8	4553	27 September 2019

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Dashboard_Dropdown doesn't use DataArray

Related topics