msql reports-route-columns

amin imanian2 years ago

The value of the temperature sensor from my teltonika gps device is stored in the mysql database in the attributes table with the name and value "io72":13, but it is not visible in the reports-route-columns section. How should I add it in this section?
Thankful

Anton Tananaev2 years ago

You can convert it into some known attribute, depending on what value represents. And then you can add it as a column.

amin imanian2 years ago

Can I add an attribute named io72 in the program source? Because there are several sensors whose data must be sent and stored in the database. And in which part of the program can I make this change.

Anton Tananaev2 years ago

Yes, of course you can add it in the source code.

Nikolay 2 years ago

If you want it to be visible only in the web report, you can try Here and Here.
If you want it to be visible in the export, you need to change the template of the report itself Here

I don't think you need to edit or add anything in the Java source.

The database stores all the sensors in the attributes column of the tc_positions table as a json string. If you want to retrieve data from there you will need to cast those attributes as json depending on the database selected.
If you want to have a separate column in the table for a specific sensor, you better not consider it.