Filter 6 months past position

cristianormoraes3 years ago

There are filter for past positions? eg. 6 months old positions?

Anton Tananaev3 years ago

Filter?

cristianormoraes3 years ago

Yes, I have some gps tracker with firmware issue, some time they sent position in the past, eg. 10/02/2015 .....

Anton Tananaev3 years ago

You can override insert query to ignore old data.

cristianormoraes3 years ago

I was created a mysql trigger before inser position:

if (NEW.servertime < DATE_ADD(NOW(), INTERVAL -3 MONTH)) then
    signal sqlstate '45000';
END if;

but, just want know if traccar already have it

thank you Anton !