{"action":"opened","issue":{"url":"https://api.github.com/repos/tananaev/traccar/issues/2474","repository_url":"https://api.github.com/repos/tananaev/traccar","labels_url":"https://api.github.com/repos/tananaev/traccar/issues/2474/labels{/name}","comments_url":"https://api.github.com/repos/tananaev/traccar/issues/2474/comments","events_url":"https://api.github.com/repos/tananaev/traccar/issues/2474/events","html_url":"https://github.com/tananaev/traccar/issues/2474","id":184706274,"number":2474,"title":"Feature Request : Delete Positions With a certain Value","user":{"login":"jaimzj","id":1138485,"avatar_url":"https://avatars.githubusercontent.com/u/1138485?v=3","gravatar_id":"","url":"https://api.github.com/users/jaimzj","html_url":"https://github.com/jaimzj","followers_url":"https://api.github.com/users/jaimzj/followers","following_url":"https://api.github.com/users/jaimzj/following{/other_user}","gists_url":"https://api.github.com/users/jaimzj/gists{/gist_id}","starred_url":"https://api.github.com/users/jaimzj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jaimzj/subscriptions","organizations_url":"https://api.github.com/users/jaimzj/orgs","repos_url":"https://api.github.com/users/jaimzj/repos","events_url":"https://api.github.com/users/jaimzj/events{/privacy}","received_events_url":"https://api.github.com/users/jaimzj/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-10-23T18:32:07Z","updated_at":"2016-10-23T18:32:07Z","closed_at":null,"body":"Dear All,\r\n\r\nI am not sure how many of us here would find this feature request useful, but I will still go ahead and list it here,. In-case any or few might up vote this :)\r\n\r\nAs there is already a feature to disable positions older than x number of days.\r\n\r\nI have a scenario where some chinese devices, like TK103, etc. Keeps sending Data with New `fixtime or devicetime` even when the vehicle/device is static/stationary. In such a case even the filter duplicate feature would not work, as it checks for the time.\r\n\r\nSo to remove such records,. I had been usually running a direct MySQL query to delete all records, which had protocol column a certain value lets say GPS103, and speed value = 0\r\n\r\nSo for a better option, which can be adapted or used as and how users require, based on device specific data. here is my feature request\r\n\r\n\r\n1. User can configure columns, and the values it should contain.\r\n2. And the frequency at which this delete option should run.\r\n3. And at that set interval/frequency, the server would check for the position table, specified columns for the set values, and delete them.\r\n\r\nI am thinking of using it to clear all junk values, such as GPS Data received when vehicle is stationary. etc.,"}}
{"actor":{"display_login":"jaimzj"}}