Get list of table types
To get the list of tables which can be included in reports, use the command report/get_report_tables:
svc=report/get_report_tables¶ms={}
Response
[
{
"id":<uint>, /* table ID */
"n":<text>, /* system table name */
"l":<text>, /* default table name */
"t":<text>, /* table type */
"ct":<text>, /* type of template in which this table can be used */
"pt":<text>, /* text parameters */
"gt":<text>, /* advanced grouping settings */
"col":[ /* array of columns */
{
"n":<text>, /* system column name */
"l":<text>, /* default column name */
"sl":<text>, /* list of column headers (if it is a statistics table) */
"t":<text>, /* column type */
"f":<uint> /* column flags (see below) */
}
]
}
]
Report template types are described in the chapter Get templates data.
Column flags
Flag | Description |
0x01 | show as table column |
0x02 | show as statistics column |
0x04 | show as global switcher |
0x08 | show as column with position data |
0x10 | show as chart axis |
Values for "pt"-param
Value | Description |
geozones | Geozones/units |
unfinished_ival | Unfinished interval |
duration | Duration |
mileage | Mileage |
base_eh_sensor | Engine hours sensor |
engine_hours | Engine hours |
speed | Speed |
trips | Trips |
stops | Stops |
parkings | parkings |
sensors | Sensors |
sensor_name | Sensor mask |
driver | Driver |
trailer | Trailer |
fillings | Fillings |
thefts | Thefts |
duration_format | Furation format |
geozones_ex | Extended geozones/units |
username | Username mask |
route_points | Route points |
event_mask | Events mask |
rides | Rides, applicable for “Unit”-“Unfinished rides”, “Unit group”-“Rides” |
fields_config | Fields type, applicable for “Custom fields” tables |
units | Units, applicable for “Maneuvers” tables |
interval | trace interval in minutes, applicable for “Unit” -“Sensor tracing” |
group_zones_pass | “Consider group as a whole” option is available, applicable for “Unit group”-“Non-visited geofences” |
routes | applicable for “Routes” tables |
last_location | “Consider report interval” option is available, applicable for “Unit latest data” table |
hide_total | “Total” checkbox is hidden for that table |
groupitem | “Group itself” option is available, applicable for “Unit group” –> “Log” and “Custom Fields” tables |
noschedule | No “Time limitation” option available, applicable for “Summary” and “Latest unit data” tables |
hide_driver_split | “Retrieve intervals” checkbox is hidden in driver filter |