I have a problem in the code, that is, when the data sensor is sent, the database is not given the data of the other two sensors, the idea was when one sensor stops and the other two continue to send the data but what stopped you should send a null to the database so that we can see that the sensor …

Look at the config you have entered for the Join node, there is an option to specify a timeout.

I used the tip of the timeout and when I turn off the sensor count meters, it in the database is so undefined, which is more or less what I wanted as shown in the figure as well as I took the toFixed following the advice, however I would like ask if there is a way to send eg a way to show that it is…

What data type is that column in the database?

I set the all columns to VARCHAR (255)

In that case put a Function node after the Join node that checks the values and adds in any missing ones with whatever value you want.

I make this, but the sensor is always ON, how make when the sensor not count meters pass to OFF state? [{"id":"9c5ae5dc.8b7f08","type":"tab","label":"Flow 2","disabled":false,"info":""},{"id":"1f6e701c.af967","type":"function","z":"9c5ae5dc.8b7f08","name":"","func":"if (msg.payload[\"n=2;s=SensorIn…

Can you explain in words what the function is supposed to do? I thought you were wanting to write to the database.

[image] Colin: Can you explain in words what the function is supposed to do? I thought you were wanting to write to the database. What I want to do is to have an ON and OFF message on the dashboard that indicates that the sensor is active or inactive I want the function to do, but I think I'm…

[image] smalhao: What I want to do is to have an ON and OFF message on the dashboard OK, I thought you wanted to get that information into the database. In that case put a debug node showing what is coming in through the link node in the flow.

[image] Colin: OK, I thought you wanted to get that information into the database. In that case put a debug node showing what is coming in through the link node in the flow. in the inject or the subscribe? [image]

Node-RED

Node-RED Forum

Database not receive the data when one sensor stops

General

dceejay 14 February 2019 11:20 36

Moved to Show if sensor is ative or inactive

Topic		Replies	Views
Insert multiple sensors data into mysql General	10	270	5 March 2024
Input multiple sensor outputs into mysql General	12	2008	2 November 2020
Trouble entering data to mysql General	10	2075	15 May 2020
MySQL NODE-RED table General	33	11799	8 February 2019
Aggregate MQTT sensor values into influxdb General	4	1144	3 February 2020

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.

Database not receive the data when one sensor stops

Related topics