Hello, I am working on a project and I need to show some values from a mysql database in a dropdown node. It doesn't work, can anyone help me? [{"id":"b4621290.54dd1","type":"mysql","z":"e6d7a892.242908","mydb":"b004cfb2.cc7a7","name":"Temp.servicetools","x":670,"y":240,"wires":[["61c62a4a.7859e4"…

[{"id":"aedb14f9.8d6008","type":"inject","z":"5896831d.0ddf0c","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":140,"y":160,"wires":[["9406f167.f0408"]]},{"id":"9406f167.f0408","type":"function","z":"5896831d.0ddf0c","name":"SQL query"…

The array I want to use from the database is variable so if I just copy the text and I want to change the database then I need to change the program to. I would like that if the database changes I don't need to change the program.

You are only grabbing the data and putting it into the inject node so you can test how things will work without having to access the database while testing. With actual data, you can test out your code to build the dropdown. Once it is done, you will just connect up the output of the mysql node to t…

thanks for your help! The dropdown node works! If I open the dropdown node it only shows the label. Do you know how to set the node that it shows the value?

Not sure what you are asking. In the drop down you can have a label and value. The label is displayed and when you pick one, its value is used. If you send only a label it is used as the value

{"id":"7ea82093.8b0e9","type":"inject","z":"5896831d.0ddf0c","name":"","topic":"","payload":"1","payloadType":"num","repeat":"60","crontab":"","once":false,"onceDelay":0.1,"x":190,"y":100,"wires":[["9406f167.f0408"]]},{"id":"9406f167.f0408","type":"function","z":"5896831d.0ddf0c","name":"SQL query",…

[image] How to share code or flow json FAQs To share code samples or flow json in this forum, you need to take care to format it properly so that it is displayed correctly. The easiest way to do that is to click the 'Preformatted Text' button in the toolbar: [image] The…

Thanks for your help! Ive changed it.

your flow still can not be imported. your back tics missed the begining '[' and you included the letters 'th' of the word 'this' following the flow. That said, how many columns are you retrieving in the sql statement? what does the Node help for the ui_dropdown say when you use msg.option? (…

I have changed the flow. I retrieve one column and I don't understand where I can specify the array.

put a debug on the output of your mysql node - what does it show? is it an array or a string or an object?

Node-RED

Node-RED Forum

Mysql database in dropdown node

Dashboard

bakman2 21 May 2019 07:42 12

1 Like

Topic		Replies	Views
UI Dropdown - get result from SQL Dashboard	50	18916	12 November 2018
UI Dropdown - Populating Data General	28	20681	30 July 2021
Data into dropdown General	29	830	9 August 2022
Dashboard_Dropdown doesn't use DataArray Dashboard	12	1072	12 March 2020
Populate data from database into Dropdownlist General	8	4635	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.

Mysql database in dropdown node

Related topics