Get data from attributes without using json OpenGTS and traccar version higher than 4.10

controlsata year ago

First of all greet all members of this community,
I have opengts installed with mysql that does not support json.
I was seeing other comments where they use the extracvalue:

EXTRACTVALUE( :attributes , '/info/batteryLevel' )

but I do not get any data, it is always empty; I only get data if I put :attributes.
Maybe '/info/batteryLevel' should no longer be used, although I already tried using only '/batteryLevel'
Could you confirm if the way of obtaining this data has changed, using extractvauel?

Anton Tananaeva year ago

How is this related to the Traccar server?

controlsata year ago

what I am doing is integrating opengps with traccar, this is already working; but i want to get data like battery level from attributes generated in traccar and store it in opengts. I know one method is using JSON(); but my mysql doesn't support it.

Anton Tananaeva year ago

How about this:

https://stackoverflow.com/a/31127857/2548565