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;

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	3937	15 April 2019
Populate data from database into Dropdownlist General	8	4580	27 September 2019
Dashboard_Dropdown doesn't use DataArray Dashboard	12	1043	12 March 2020
Mysql database in dropdown node Dashboard	31	4341	22 May 2019
UI Dropdown - get result from SQL Dashboard	50	18856	12 November 2018

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