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"…

Your flow is still bad, I see it is missing the original open bracket. Try inserting the flow all over again and as a test, once you have saved the post, see if you can import it.

Ok, it finally imports! So let's look at how you can solve this problem. First check what data is coming out of the mysql by sticking a debug node on the output of the mysql node, change the debug node to display the 'complete msg object'. Run it and then look at the debug tab in the right sidebar.…

Thanks for your help! How do you put the data from the array in the inject node? Can you tell some more about the change node?

[image] niels_devos: How do you put the data from the array in the inject node? If you look at the debug output in the sidebar you will see a couple small icons on the right. If you hover on them the tool tip will show up. the middle not [DATA_COPY] will copy the data. Now look at the inje…

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",…

Node-RED

Node-RED Forum

Mysql database in dropdown node

Dashboard

zenofmud 15 May 2019 11:14 2

please edit your post after reading this thread: How to share code or flow json

1 Like

Topic		Replies	Views
UI Dropdown - get result from SQL Dashboard	50	18943	12 November 2018
UI Dropdown - Populating Data General	28	20681	30 July 2021
Data into dropdown General	29	864	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