Hello, i would like to read a value from a SQL database and use the value in my flow. its my first attempt to do that and i have a Problem, Maybe based on msg structure misunterdstanding. Here is a Picture of the part of the Flow: [flow] Here the part of the flow: [{"id":"17fd4fda.6273f","type"…

Hi, on of my attempts was msg.payload.Zeitausgabe = msg.payload.0.Getriebe_Betriebsstunden; but didnt work :slight_smile: sadly msg.payload.Zeitausgabe = msg.payload[0].Getriebe_Betriebsstunden; doesnt give me the value :frowning:

It does give you the value. [Screenshot 2020-08-20 at 10.13.22] What does your output look like ?

if i use : msg.payload.Zeitausgabe = msg.payload[0].Getriebe_Betriebsstunden; i get : [payload Weitergabe output2] so Nothing changed… My hope was for: Zeitausgabe = 00:01 :slight_smile:

Can you post you full flow with some dummy input ? (ie. dont use the mysql nodes as we cannot replicate). ah no you cannot set it to: msg.payload.Zeitausgabe because msg.payload is already an array. If you set it to msg.Zeitausgabe or remove msg.payload first.

sorry but its to big to post, so i have to post that part. what i can give is a bigger overview: [überblick]

See previous response: You cannot set it to msg.payload.Zeitausgabe because msg.payload is already an array. Set it msg.Zeitausgabe or remove msg.payload first.

You should be able to use msg.payload = {Zeitausgabe: msg.payload[0].Getriebe_Betriebsstunden}

So, i used : msg.topic = "ATESTEO/Wolfsburg/W03"; var Buffer; Buffer = msg.payload[0].Getriebe_Betriebsstunden; delete msg.payload msg.Zeitausgabe = Buffer; return msg; so i get rid of the Array too.. Thank you both for your help!!!

I advise against using a variable called Buffer, buffer is a keyword in javascript. In this case what you have will work ok, but it may cause confusion in the future. Also the convention in javascript is not to start variables with a capital letter, again it will not stop it working but the code w…

ok i will Change that. i think i stumbled in an other problem but i will think about that first :slight_smile:

Node-RED

Node-RED Forum

Problem getting Value from SQL SELECT

Dashboard

bakman2 20 August 2020 08:03 2

The payload is an array with an object, you can retrieve it like:

msg.payload[0].Getriebe_Betriebsstunden

Topic		Replies	Views
Getting Value from Payload Dashboard	8	976	7 December 2020
How to read specific value from Array General	11	7115	30 August 2022
Extracting a value from an MS-SQL database General database	9	968	2 May 2022
Msg split, choose option and MySQL select General	45	2149	23 April 2020
Read SQL value and convert to Domoticz MQTT Topic - payload issue General	24	2230	23 August 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.

Problem getting Value from SQL SELECT

Related topics