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.

Here you see the export of the flow: [{"id":"5652cf9d.e232e","type":"tab","label":"Diagramme","disabled":false,"info":""},{"id":"ec61f421.769e88","type":"inject","z":"5652cf9d.e232e","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":true,"onceDelay":0.1,"x":130,…

Please add a debug node to the output of the SQL node so I can see what the data looks like.

The first on is the debug node of the SQL Node, the second on is the formated data. [grafik]

Are you seeing the dropdown list in the dashboard?

Yes I see the Dropdown on the Dashboard. [grafik] But there are no options inside. [grafik]

Do you press the inject button before looking at the dashboard? If so, try this, add this to your flow (an inject and chnange node and connect it to your ui-drodown and press the inject button. Then see what is in the dashboard [{"id":"56272c78.bdbe9c","type":"inject","z":"ba53629d.ec0638","name":…

The Dropdown Menu doesn't change. It looks like before

I have to change my answer. I tried it again and kow I see this: [grafik] Sorry :grimacing:

Ok! so now put a debug node on the output of the change node I gave you and run it. Now examine its output and the output of your function node feeding the chart. What differences do you see?

Node-RED

Node-RED Forum

Dashboard_Dropdown doesn't use DataArray

Dashboard

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	4439	22 May 2019
UI Dropdown - get result from SQL Dashboard	50	18949	12 November 2018
UI Dropdown - Populating Data General	28	20692	30 July 2021
Setting Dropdown in input text node Dashboard node-red-dashboard	3	181	12 January 2024
Populate data from database into Dropdownlist General	8	4641	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