Hi node-red forum, Is it possible to pass a msg payload to SQL query node to use in the where cluase? I mean somenthing like this: [immagine] Which is the correct syntax? The path of the msg payload to pass is payload.topic1[0].ID

Sure, however you need to. e.g. ↓ When the value XXX comes from msg.payload[0].ID ↓ then... SELECT * FROM T1 where id=XXX becomes SELECT * FROM T1 where id=@ID and add a parameter for msg.payload[0].ID named ID

[image] QGIO: Which is the correct syntax The "better" way is to use "Parameters" [image] Node-red-contrib-mssql-plus => value in database is empty General Hi, so a couple of things first. Please post code between backticks ``` like this ``` When copying values from the debug sidebar, use the "Copy Value" button that appears under your mouse cursor when you hover over the message [BX00Cy7yHi] On you your issue... The debug BEFORE SQL shows payload is an array but in your SQL, you try to access payload.ts_pos_wo_id - an array is accessed by [] square brackets. To simplify things (and avoid mistakes) use the "Copy Path" button that ap…

Thanks Steve. Also if I'm using a Select query (not Insert into)? I want to make a merge between two table and extract only raw where the ID is the one passed by a previous function output.

Parameters work with all types of queries (SELECT/UPDATE/INSERT/DELETE! I dont think i fully understand what you are asking Can you explain with a bit more detail please?

Do you mean to use 'parameters' like in this way? [immagine]

Node-RED

Node-RED Forum

Pass msq payload to SQL query where clause

General

Steve-Mcl 23 March 2022 10:35 2

The "better" way is to use "Parameters"

Topic		Replies	Views
MSSQL-Plus - Appending the Query output to incoming payload.msg General	2	433	24 August 2021
How to access msg.payload array in mssql? General	9	2630	27 May 2020
Using msg.payload in a SQL query General	7	9543	23 June 2020
Payload to SQL query General database	2	594	7 October 2021
Filter a SQL query with variables from a previous one in Node Red General	11	581	6 October 2022

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.

Pass msq payload to SQL query where clause

Related topics