Hi, I'm new here
(sorry, english is not my native language)
I got a "special" question about the possibility of filtering out every second trigger-event from an MQTT-input-node.
Why?/Background: I recreated this fantastic setup from Andreas Spieß: https://www.youtube.com/watch?v=L0fSEbGEY-Q . With the help of the SDR-stick and "rtl_433" I receive the values of the outdoor weather station (WH1080) of my neighbor on my RaspberryPi. These datagramms where convertet to MQTT-Messages which I handle with node-red to display the values in the dashboard. This works fine and looks great. Additional I installed MySQL to the RasPi to archive these values for later fun. This works also fine.
Problem: On every time the wheather-station sends (about every 50 seconds), it sends its values twice directly one after the other! So node-red receives two MQTT-Messages and my flow starts also twice (in nearly the same time) This is no problem for watching the values live on the dashboard. But now i have the double values in the MySQL-Database. Sometimes it differs one second, sometimes I got an MySQL-Error because the timestamp is the same.
The goal is, to have only one (set of) value(s) every 50s. Is there an elegenat way to "filter out" every second event?
Thanks for your ideas!