Configuration of Device Settings e.g. "filter.static"

depth7503 21 days ago

Is this the correct? Does it require anything other than "save" to be applied? Could it be a string as well if the value were true or false?

2026-06-02-qzfhZYODGQ.png

Anton Tananaev 21 days ago

Looks correct.

depth7503 2 days ago

It seems to me that filter.static would filter out position# 982719, however it did not. Any theories?

SELECT id, servertime, devicetime, fixtime, valid, altitude, speed, course, accuracy, network, attributes
FROM tc_positions
WHERE deviceid = 7
  AND fixtime BETWEEN '2026-06-20 20:10:00' AND '2026-06-20 21:20:00'
ORDER BY fixtime;
id    |servertime             |devicetime             |fixtime                |valid|altitude|speed     |course|accuracy|network|attributes                                                                                                                                                   |
------+-----------------------+-----------------------+-----------------------+-----+--------+----------+------+--------+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
982697|2026-06-20 20:10:45.394|2026-06-20 20:10:46.074|2026-06-20 20:10:46.074|true |    -5.1|24.6284528|  18.0|     0.0|null   |{"motion":true,"odometer":4156075,"activity":"in_vehicle","batteryLevel":56,"distance":1039.9498460104994,"totalDistance":4460032.216129135}                 |
982705|2026-06-20 20:11:42.629|2026-06-20 20:11:43.076|2026-06-20 20:11:43.076|true |  -12.42|19.9437984| 333.0|     0.0|null   |{"motion":true,"odometer":4156181,"activity":"in_vehicle","batteryLevel":56,"distance":92.77490955156938,"totalDistance":4460124.991038687}                  |
982716|2026-06-20 20:21:16.653|2026-06-20 20:21:17.085|2026-06-20 20:21:17.085|true |  -13.06| 4.9956688|265.53|     0.0|null   |{"motion":true,"odometer":4156381,"activity":"walking","batteryLevel":56,"distance":197.3382046254854,"totalDistance":4460322.329243312}                     |
982719|2026-06-20 20:29:31.278|2026-06-20 20:29:26.712|2026-06-20 20:29:26.712|true |  -12.53|       0.0|   0.0|     0.0|null   |{"event":"motionchange","motion":false,"odometer":4156381,"activity":"still","batteryLevel":56,"distance":9762.74937157704,"totalDistance":4470085.078614889}|
982726|2026-06-20 20:40:12.708|2026-06-20 20:40:11.996|2026-06-20 20:40:11.996|true |    -3.0| 2.4492384|345.03|     0.0|null   |{"motion":false,"odometer":4156381,"activity":"still","batteryLevel":54,"distance":9741.353433580874,"totalDistance":4479826.43204847}                       |
982738|2026-06-20 21:05:20.833|2026-06-20 21:05:20.022|2026-06-20 21:05:20.022|true |   26.19| 0.9330432| 162.0|     0.0|null   |{"motion":false,"odometer":4156447,"activity":"still","batteryLevel":52,"distance":12.016581542423628,"totalDistance":4479838.448630013}                     |

2026-06-21-dbeaver_TlEu8G7GAH.png

Anton Tananaev 2 days ago

What's your full configuration?