{"action":"created","issue":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/1127","repository_url":"https://api.github.com/repos/vitalidze/traccar-web","labels_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/1127/labels{/name}","comments_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/1127/comments","events_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/1127/events","html_url":"https://github.com/vitalidze/traccar-web/issues/1127","id":228356761,"number":1127,"title":"accessing position.other","user":{"login":"EsajeeSolutions","id":6302184,"avatar_url":"https://avatars0.githubusercontent.com/u/6302184?v=3","gravatar_id":"","url":"https://api.github.com/users/EsajeeSolutions","html_url":"https://github.com/EsajeeSolutions","followers_url":"https://api.github.com/users/EsajeeSolutions/followers","following_url":"https://api.github.com/users/EsajeeSolutions/following{/other_user}","gists_url":"https://api.github.com/users/EsajeeSolutions/gists{/gist_id}","starred_url":"https://api.github.com/users/EsajeeSolutions/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/EsajeeSolutions/subscriptions","organizations_url":"https://api.github.com/users/EsajeeSolutions/orgs","repos_url":"https://api.github.com/users/EsajeeSolutions/repos","events_url":"https://api.github.com/users/EsajeeSolutions/events{/privacy}","received_events_url":"https://api.github.com/users/EsajeeSolutions/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-05-12T17:25:20Z","updated_at":"2017-05-12T17:38:33Z","closed_at":null,"body":"do i need to parse position.other every time ? can i access sensors data directly instead of position.other\r\n"},"comment":{"url":"https://api.github.com/repos/vitalidze/traccar-web/issues/comments/301139898","html_url":"https://github.com/vitalidze/traccar-web/issues/1127#issuecomment-301139898","issue_url":"https://api.github.com/repos/vitalidze/traccar-web/issues/1127","id":301139898,"user":{"login":"vitalidze","id":2294325,"avatar_url":"https://avatars3.githubusercontent.com/u/2294325?v=3","gravatar_id":"","url":"https://api.github.com/users/vitalidze","html_url":"https://github.com/vitalidze","followers_url":"https://api.github.com/users/vitalidze/followers","following_url":"https://api.github.com/users/vitalidze/following{/other_user}","gists_url":"https://api.github.com/users/vitalidze/gists{/gist_id}","starred_url":"https://api.github.com/users/vitalidze/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vitalidze/subscriptions","organizations_url":"https://api.github.com/users/vitalidze/orgs","repos_url":"https://api.github.com/users/vitalidze/repos","events_url":"https://api.github.com/users/vitalidze/events{/privacy}","received_events_url":"https://api.github.com/users/vitalidze/received_events","type":"User","site_admin":false},"created_at":"2017-05-12T17:38:33Z","updated_at":"2017-05-12T17:38:33Z","body":"Sensor data is stored in `position.other`. It is dynamic, that's why it is stored as JSON text (or XML text in older versions). So, yes, you need to parse it. From my memory newer versions of MySQL allow to run queries against JSON data stored in columns, you can try using this functionality. I haven't tried it myself though."}}
{"actor":{"display_login":"vitalidze"}}