Hi, in my flow if I open the switch I go through MySQL database to get the last value of field level after it sends value to the function FN to recover this value as a time remains the switch running. I take an example with this scenario: click switch "on" after I take the last value in our databa…

Check your school boy error inside the brackets of your if on line 1. Use == not =

Ps, the exclamation mark on line 1 tells you the problem.

but when I click on the switch it always remains in active state and the debug node does not show anything

So your function node will only return anything if the if statement is true. Add logging events to your function node to see what you are actually passing and to check your logic. https://nodered.org/docs/writing-functions#logging-events

Look at line 1. You actually set the payload to a string 'true'. Then in line 2, t get set to a string 'true' therefore your timeout doesn't work!!!!

Actually, msg.payload cannot be 'true' and a value. It's either one other the other. Perhaps you should do ... var t = msg.payload; if(t){ //Set timer etc etc }

if(msg['payload'] == 'true'){ var t = msg.payload; if(t){ setTimeout(function(){ node.status({fill:"red", shape:"ring", text:" "}); msg['payload'] = 'true'; node.send(msg); }, t); } node.status({fill:"blue", shape:"ring", text:' '}); } debug node does not show anything, msg.payload it'…

Put a debug node before this function node. See what is in msg.payload. You do realise that msg.payload is the same as msg['payload'] right? //If msg payload is actually == true if(msg['payload'] == 'true'){ //Then it cannot magically be a number. var t = msg.payload; So if msg.payload is actua…

with this function the node red is blocked for your question " You do realise that msg.payload is the same as msg['payload'] right?" I mean msg.payload it's the value of mysql. msg['payload'] is the state of Switch node "true" or "false"

Node-RED

Node-RED Forum

Timer the Switch with mysql database

General

Steve-Mcl 1 April 2019 12:18 6

That's because inside the if, you set msg.payload to true.

Do what I said and change the assignment = to comparison ==

Topic		Replies	Views
Switch node not Consistent General	22	2048	18 September 2021
Node-red : switch - strange behaviour General	14	590	7 May 2022
Switching based on objects General	9	232	26 October 2025
How can i get the payload from a mariaDB to a switch node General	7	264	4 May 2021
If ( var1 = true and var2 = true ) then / else General	38	87287	16 February 2021

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.

Timer the Switch with mysql database

Related topics