I read a few posts on the UI dropdown but I am not able to see my test data. I created a function to create an array of data: msg.payload = [ "Name1","Name2","Name3","Name4" ] return msg; Used the change node: [image] My /ui is not displaying the values. Do I need to identify something in the…

[image] Steve-Mcl: [{"id":"c5e1961a.63c208","type":"inject","z":"9f43aee.ab3dc5","name":"Fake DB Result","topic":"","payload":"[{"part_number_item":"17260851BD"},{"part_number_item":"17299989AC"},{"part_number_item":"17246783FB"}]","payloadType":"json","repeat":"","crontab":"","once":true,"onceD…

Dear Andrei, i was looking for some tips for creating the list of elements out of the array returned from the MySQL query, but havn't found any. The only solution here is a setting already predefined list (array) of strings, to push it to the dropdown list. Could you please suggest how i can access …

can you share an example of what the existing array looks like and which parts need to be in the dropdown ?

Hi, I dont have a MySQL to play with so I have simulated data with an inject node & fully commented a function node to help you. The heart of this solution is to transform whatever format you get from the database (use a debug node to determine that) into a format the dropdown node likes (see the i…

Hi Liudmila, welcome to the forum. I am late to the party as Steve already provided a nice working example. If you share with us how the returned MySQL query looks like and how the dropdown should be then we could see how the solution from Steve could be adapted to fit your use case.

Hi, thanks, i didn't expect so many reply at so short time, i'll go throu all of them... meanwhile here is a flow i'm trying to create. [{"id":"10759ae0.91fbd5","type":"change","z":"320f5181.7a99c6","name":"part_number_item_test1","rules":[{"t":"set","p":"options","pt":"msg","to":"payload","tot":"…

[image] Steve-Mcl: [{"id":"4526cd47.623524","type":"inject","z":"4ee0e132.e7df2","name":"Fake DB Result","topic":"","payload":"[[\"bob\",1],[\"rita\",2],[\"sue\",3]]","payloadType":"json","repeat":"","crontab":"","once":true,"onceDelay":0.1,"x":160,"y":320,"wires":[["e2acd642.38aa98"]]},{"id":"e…

Since the structure of your data matches the structure of the dropdowns required msg.options you're getting exactly what you give it. What is it you want displayed in the dropdown & what do you want for the value when its selected? According to your screen shot you have "part_number_item" or its "…

See my second response above ^ :slight_smile:

Can i ask you one more question thought, everything is working, but the first time it gave me such an ugly screen: [immagine] when i choose one of the value everything is gone, but the first time i get all the returned values on the screen. What's wrong with my flow?

Node-RED

Node-RED Forum

UI Dropdown - Populating Data

General

ukmoose 16 April 2019 08:23 11

Unfortunately your flow isn't currently importable.Please read the following post How to share code or flow json and then edit the above message.

Topic		Replies	Views
Mysql database in dropdown node Dashboard	31	4478	22 May 2019
UI Dropdown - get result from SQL Dashboard	50	19003	12 November 2018
Data into dropdown General	28	878	10 June 2022
UI Dropdown trying to allow for single entry or multiple Dashboard	25	4017	15 April 2019
Populate data from database into Dropdownlist General	8	4657	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.

UI Dropdown - Populating Data

Related topics