Pass msq payload to SQL query where clause

[QGIO]

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:

Which is the correct syntax?

The path of the msg payload to pass is payload.topic1[0].ID

[Steve-Mcl]

@QGIO

Which is the correct syntax

The "better" way is to use "Parameters"

Node-red-contrib-mssql-plus => value in database is empty

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…

[QGIO]

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.

[Steve-Mcl]

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?

[QGIO]

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

[Steve-Mcl]

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