Hello everyone i want ask if there's someone can help me in node-red flows i have msg.Payload is a counter and i want to save the total of this cumulate for each 8 hours. please any one has an ideas to help me thank you [1]

I don't understand what you are trying to count. You seem to suggest you want to record the number of times it stops and starts, but I thought you wanted to record the running time and downtime. Please tell us exactly what you want to put into the database and when it has to be added to the databa…

For what purpose do you want to save it, and for how long do you need to keep it? What are you counting?

the data is about time of stop machine and time of working and i want to send it to SQL server so i want to know how much time is it stop and how much are working i have a bool variable indicate state of machine

What exactly do you want stored in the database? To answer that question you need to know what the data will be used for in the future.

Just the duration of each state how much the false input take and how much the true state take[website-content-monitoring-records] somthing like this

There is no point saving the start time, end time and duration, as the duration can be calculated from the start and end times. Personally I would write the state to the database each time it changes, but if you don't want to do that then save the start time to the context each time it starts, and …

Thank you for your help but i still can't get my goal so I ask for your help with this flow what i need is to count the true and false state but i want the total of true or false until change the state so if the payload is true two time or 3 ... the script count but don't send it in the debug becaus…

Hi thank you so much for your time What I want to add into database is the date when the machine is stoping and when it start running My maching send a true when it's run and false when it's stop so I want to send to database when it's start and stop and not every state because the machine send ev…

I try this one it's perfectly run @Colin Just the start time update when true is inject what I want is if the true is injuct the function compare the courant state with the previous one if it's the same the function will send nothing but if it's false the will send the start and the end of the stat…

Add an RBE node before the function. The RBE node only passes on a message when the value changes.

Node-RED

Node-RED Forum

Save the cumulate data each 8 hours tracking events

General

dceejay 19 March 2021 13:52 9

There are also several previous threads that may help. like this How to calculate machine running time
and Cumulative running time

Topic		Replies	Views
Helpful criticism requested General	44	2592	17 July 2018
Store msg alone without needing to have excel ,SQLite table just by topic to payload it again to node red when needed General	39	1313	7 August 2021
Data get from SQLite General	52	1684	7 March 2022
Totalizer difference example General	32	3273	20 April 2021
Store data on a database General	17	10760	13 March 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.

Save the cumulate data each 8 hours tracking events

Related topics