Hello forum, I have a problem with the drop down node. I make a query by SQL node to a Database table and I get the desired result. This result is then linked to a dropdown node, but I have a problem just in one case. When the result of my query is an array with just one object like this: [immag…

And there is the problem - it is not an array. [image] JSONata expression payload.ID_Scad[] in change node should work. If not, then a function node equivalent would be msg.payload = msg.payload.map(e => e.ID_Scad); return msg;

Put a debug node after the change node (set to show complete message) - what do you see? Then, compare your data to the example in the built in help of the drop down node, does your options match the required format?

Here it is the debug node result of change node [immagine] I see the array is not empty, but I don't see in the UI dropdown list

I followed this link [image] UI Dropdown - get result from SQL Dashboard Have some data from a MSSQL node that I want to insert as values in a Dropdown node, so I can return the selected value. But have searched high and low, but have not found and examble I can use Dat…

You did not set debug node to show complete message. I cannot see msg.options so you can't have compared it to the built in help.

When you use this JSONata expression: $.payload.ID_Scad it returns an array of values ONLY if there are more than one IDs found in the payload array. Otherwise it is flattened to a single value (as you found out the hard way). I'm guessing that the dropdown node is always expecting an array of va…

[image] QGIO: but it doesn't work, when I have just one object I don't see it in the dropdown. As i said twice... [image] Steve-Mcl: Put a debug node after the change node (set to show complete message) This will let us see what you are sending in msg.options to the drop down node.

Node-RED

Node-RED Forum

Dropdown node does not show query result when it is a array[1]

General

QGIO 25 March 2022 09:29 4

I followed this link

Topic		Replies	Views
UI Dropdown trying to allow for single entry or multiple Dashboard	25	3979	15 April 2019
Populate data from database into Dropdownlist General	8	4648	27 September 2019
Dashboard_Dropdown doesn't use DataArray Dashboard	12	1086	12 March 2020
Ui_dropdown - "ERR: Invalid Options" Dashboard	16	724	8 December 2021
UI Dropdown - Populating Data General	28	20694	30 July 2021

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.

Dropdown node does not show query result when it is a array[1]

Related topics