Update SQL Table of multiple rows with different identifiers

[Kimo]

Hi. I been stuck for some days figuring out how I can update multiple rows of a sql table which have different identifier. Inside my flow, when user key in an input, the data will send to sql table also to a ui table the same time as shown below with red area. Then, user will press start to log the start timestamp and update the timestamp into sql table. However, if user can submit data multiple times bfore pressing start, how I can update these data with same timestamp?

Here attach also the flow for reference. Thank you for the help.
example.json (19.9 KB)

[Kimo]

Or maybe anyone here know how to update sql table if the id is in array?

[karlbo]

could you show what comes from the join msg and the insert into DB?
not knowing what it says there, its impossible to be of any help to you.

[Kimo]

Nevermind. Thank you for replying. I have managed to solve this. Everyone have same application can refer to this post below. Thank you

How to update SQL query with an identifier has 2 strings

that is not what I said to do... e.g.. const array = flow.get('array'); //example ["A1", "A2"]; if(!array || !array.length) { node.warn("array is empty"); return null // halt flow } const whereClause = "(" + array.map(e => "'" + e + "'").join(",") + ");" const now = new Date().toLocaleString("en-GB"); msg.payload = "UPDATE [dbo].[Background] SET [Start_Time] = '" + now + "' WHERE [Name] in " + whereClause; return msg;