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 - get result from SQL Dashboard	50	18777	12 November 2018
Dashboard Dropdown node Dashboard	12	2850	11 June 2020
Dashboard_Dropdown doesn't use DataArray Dashboard	12	977	12 March 2020
SQL node to droplist General node-red-dashboard	2	290	3 September 2021
Mysql database in dropdown node Dashboard	31	4214	22 May 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.

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

Related topics