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&params={}

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
Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon info@gurtam.com   |   Copyright © 2002-2024 Gurtam