Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
user:reports:templ:contents:tables:filtration [28/09/2018 16:08]
tagr WH-303
user:reports:templ:contents:tables:filtration [23/01/2019 15:15]
tagr WH-830
Line 12: Line 12:
 :!: All filters except the mileage filter work only with integer values. ​ :!: All filters except the mileage filter work only with integer values. ​
  
-**Additional parameters** +**Additional parameters**\\
 The filter is available for the //​[[user/​reports/​tables/​drive|Eco driving]]// table. When the //Show all trips// option is activated, all trips, not just trips with violations, are included in the report for units with customized eco-driving parameters. The filter is available for the //​[[user/​reports/​tables/​drive|Eco driving]]// table. When the //Show all trips// option is activated, all trips, not just trips with violations, are included in the report for units with customized eco-driving parameters.
  
-**Counter sensor value range** +**Counter sensor value range**\\
 This filter can only be used for the //Counter Sensors// and //Fuel Traffic// tables. It allows to display in the report the intervals at which the messages with values that are within the specified limits are received. This filter can only be used for the //Counter Sensors// and //Fuel Traffic// tables. It allows to display in the report the intervals at which the messages with values that are within the specified limits are received.
  
-**Custom ​sensors ​masks**+**Custom ​fields ​masks**\\  
 +The filter is available for the //​[[user/​reports/​tables/​fields|Custom fields]]// table. Here you can indicate the masks that must be applied to the names of the custom fields and their values.
  
 +**Custom sensors masks**\\
 In the filter you can indicate the masks of custom sensors, which must be taken into account when generating a report on [[user/​reports/​tables/​digital|digital sensors]]. In the filter you can indicate the masks of custom sensors, which must be taken into account when generating a report on [[user/​reports/​tables/​digital|digital sensors]].
  
-**Driver** +**Driver**\\
 The filter allows to display the intervals at which the unit did not have a driver or there was a certain driver or group of drivers. If you want the report to include only the intervals at which a particular driver controlled the unit, select the //With driver// option and specify the mask of the driver'​s name in the field below. In this case, all intervals with the driver are displayed, regardless of whether the driver was present at the beginning, end, middle or along the whole interval. If the //Driver group// option is selected, only the intervals at which the vehicle was driven by any driver in the group (the mask of the name can also be specified) are analyzed when generating the report. In addition, you can activate the //Retrieve intervals// option to remove only the segments with the specified driver or group. ​ The filter allows to display the intervals at which the unit did not have a driver or there was a certain driver or group of drivers. If you want the report to include only the intervals at which a particular driver controlled the unit, select the //With driver// option and specify the mask of the driver'​s name in the field below. In this case, all intervals with the driver are displayed, regardless of whether the driver was present at the beginning, end, middle or along the whole interval. If the //Driver group// option is selected, only the intervals at which the vehicle was driven by any driver in the group (the mask of the name can also be specified) are analyzed when generating the report. In addition, you can activate the //Retrieve intervals// option to remove only the segments with the specified driver or group. ​
  
 If the //Without driver// option is selected, the table displays only the intervals at which there are segments without drivers. These segments can also be retrieved. If the //Without driver// option is selected, the table displays only the intervals at which there are segments without drivers. These segments can also be retrieved.
  
-**Duration** +**Duration**\\In the filter, you can specify the minimum and/or maximum duration of the interval. ​
- +
-In the filter, you can specify the minimum and/or maximum duration of the interval. ​ +
- +
-**Engine hours**+
  
 +**Engine hours**\\
 The minimum and/or maximum duration of engine hours. In addition, the engine hours sensor mask can be specified in the //Engine hours sensor// filter. The minimum and/or maximum duration of engine hours. In addition, the engine hours sensor mask can be specified in the //Engine hours sensor// filter.
  
-**Engine hours sensor** +**Engine hours sensor**\\
 In this filter, you can specify a mask for the name of the engine hours sensor. It affects the calculation of engine hours in the tables which have the corresponding columns, as well as the engine hours filter if it is turned on. In this filter, you can specify a mask for the name of the engine hours sensor. It affects the calculation of engine hours in the tables which have the corresponding columns, as well as the engine hours filter if it is turned on.
  
-**Event filter** +**Event filter**\\
 This filter is only available for the //Events// table. If it contains an event mask, only the events that satisfy it are included in the report. When the option //Custom events only// is activated in the filter, only [[user/​monitor/​reg#​custom_event|custom events]] fall into the report. If the option is not activated, in addition to custom events, the fields with [[user/​notify/​online|online notifications]] are also displayed in the report. This filter is only available for the //Events// table. If it contains an event mask, only the events that satisfy it are included in the report. When the option //Custom events only// is activated in the filter, only [[user/​monitor/​reg#​custom_event|custom events]] fall into the report. If the option is not activated, in addition to custom events, the fields with [[user/​notify/​online|online notifications]] are also displayed in the report.
  
-**Fuel fillings** +**Fuel fillings**\\
 The filter allows to display intervals //with// or //without fuel fillings// in the report. In the first case, you can additionally specify the minimum and maximum volume of fillings, and also activate the //Sum up fillings// option. Summing up assumes that only those intervals fall into the report, the amount of fillings on which falls within the specified limits. The filter allows to display intervals //with// or //without fuel fillings// in the report. In the first case, you can additionally specify the minimum and maximum volume of fillings, and also activate the //Sum up fillings// option. Summing up assumes that only those intervals fall into the report, the amount of fillings on which falls within the specified limits.
  
-**Fuel thefts** +**Fuel thefts**\\
 The filter allows you to display in the report intervals with fuel thefts or without them. In the first case, you can additionally specify the minimum and maximum amount of theft, and also activate the //Sum up thefts// option. Summing up assumes that only those intervals where the amount of thefts falls within the specified limits get into the report. The filter allows you to display in the report intervals with fuel thefts or without them. In the first case, you can additionally specify the minimum and maximum amount of theft, and also activate the //Sum up thefts// option. Summing up assumes that only those intervals where the amount of thefts falls within the specified limits get into the report.
  
-**Geofences/​Units** +**Geofences/​Units**\\
 This filter is divided into two parts. In the first one, you can specify the geofences by which the intervals should be filtered. In order to consider the position of the unit in any geofence or outside of it, set the radio button to the left of its name in the list from the //None// position to the '​Inside'​ or '​Outside',​ respectively. In addition to individual geofences, you can also specify their [[user/​geo/​groups|groups]]. It is the same as specifying each geofence which belongs to the group. :!: The number of geofences in a group is dynamic, that is, it changes when you change the list of geofences which belong to it. These changes are taken into account when building the report. This filter is divided into two parts. In the first one, you can specify the geofences by which the intervals should be filtered. In order to consider the position of the unit in any geofence or outside of it, set the radio button to the left of its name in the list from the //None// position to the '​Inside'​ or '​Outside',​ respectively. In addition to individual geofences, you can also specify their [[user/​geo/​groups|groups]]. It is the same as specifying each geofence which belongs to the group. :!: The number of geofences in a group is dynamic, that is, it changes when you change the list of geofences which belong to it. These changes are taken into account when building the report.
  
Line 68: Line 59:
 In the filters by geofences/​units in the //Sensors// section for the //​[[user/​reports/​tables/​fuel_traffic|Fuel Traffic]]// table, the //Include only units with tank fuelling box// option is available. It allows you to display in the report results only those units that were near the unit on the specified interval and had registered fillings. ​ In the filters by geofences/​units in the //Sensors// section for the //​[[user/​reports/​tables/​fuel_traffic|Fuel Traffic]]// table, the //Include only units with tank fuelling box// option is available. It allows you to display in the report results only those units that were near the unit on the specified interval and had registered fillings. ​
  
-**Merge intervals condition** +**Merge intervals condition**\\
 In this filter, which is available for the //Counter Sensors// and //Fuel Traffic// tables, you must specify a timeout. If you generate a timeout between some intervals less than the indicated one, the intervals are merged. In this case, firstly the merger is carried out, and then the filtration on the basis of remaining parameters is executed. In this filter, which is available for the //Counter Sensors// and //Fuel Traffic// tables, you must specify a timeout. If you generate a timeout between some intervals less than the indicated one, the intervals are merged. In this case, firstly the merger is carried out, and then the filtration on the basis of remaining parameters is executed.
  
-**Mileage** +**Mileage**\\
 In the filter, you can specify the minimum and/or maximum mileage within the interval. It can use both integer and fractional values. Use a period as the separator for fractional values. In the filter, you can specify the minimum and/or maximum mileage within the interval. It can use both integer and fractional values. Use a period as the separator for fractional values.
  
-**Parkings** +**Parkings**\\
 The filter allows you to display only those intervals within which there were parkings, or only those within which there were none. Select the //With parkings// or //Without parkings// option from the drop-down list. In the filter, you can also specify the minimum length of parking. As a result of using this option, the report on geofences, for example, displays only such visited geofences in which a parking period of at least the specified duration was detected. The //Sum up intervals// option allows you to summarize the time of parking, that is, show in the report, for example, only those geofences, the **total** number of parkings in which was not less than the specified time. The filter allows you to display only those intervals within which there were parkings, or only those within which there were none. Select the //With parkings// or //Without parkings// option from the drop-down list. In the filter, you can also specify the minimum length of parking. As a result of using this option, the report on geofences, for example, displays only such visited geofences in which a parking period of at least the specified duration was detected. The //Sum up intervals// option allows you to summarize the time of parking, that is, show in the report, for example, only those geofences, the **total** number of parkings in which was not less than the specified time.
  
-**Sensors** +**Sensors**\\
 The filter allows to display intervals in the report table with the sensor turned on or off, and, additionally,​ specify the minimum and/or maximum duration of such intervals. In order for each interval to be shown in a separate row of the table, check the //Retrieve intervals// option. Intervals can also be summed if the maximum and/or minimum duration of the sensor on/off state is specified. To specify a certain sensor, whose turning on/off should be taken into account, specify its mask in the //Sensors mask// filter. If several masks are specified, only those intervals at which all these sensors were simultaneously turned on/off are selected. If the sensor masks are not specified, the report takes into account all sensors of the unit. The filter allows to display intervals in the report table with the sensor turned on or off, and, additionally,​ specify the minimum and/or maximum duration of such intervals. In order for each interval to be shown in a separate row of the table, check the //Retrieve intervals// option. Intervals can also be summed if the maximum and/or minimum duration of the sensor on/off state is specified. To specify a certain sensor, whose turning on/off should be taken into account, specify its mask in the //Sensors mask// filter. If several masks are specified, only those intervals at which all these sensors were simultaneously turned on/off are selected. If the sensor masks are not specified, the report takes into account all sensors of the unit.
  
 :!: The intervals filtration of the //With sensor on// type works only for the digital sensors. :!: The intervals filtration of the //With sensor on// type works only for the digital sensors.
  
-**Sensors masks** +**Sensors masks**\\
 Here you can enter the sensor [[user/​gui/​masks|masks]] which will be considered when generating the report. Sensors masks affect the //Sensors// filter, //Counter// column, and information on fuel (if any of these options is selected in the report template). Note that the engine hours mask is indicated individually in the corresponding field. Here you can enter the sensor [[user/​gui/​masks|masks]] which will be considered when generating the report. Sensors masks affect the //Sensors// filter, //Counter// column, and information on fuel (if any of these options is selected in the report template). Note that the engine hours mask is indicated individually in the corresponding field.
  
-**Speed** +**Speed**\\
 In the filter, you can set the minimum and/or maximum speed within the interval. As a result, the report shows the intervals at which the speed that falls within the given limits is met at least once. If you want only those segments within which the speed does not leave the specified limits to get in the report, activate the //Retrieve intervals// option in the filter. In the filter, you can set the minimum and/or maximum speed within the interval. As a result, the report shows the intervals at which the speed that falls within the given limits is met at least once. If you want only those segments within which the speed does not leave the specified limits to get in the report, activate the //Retrieve intervals// option in the filter.
  
-**Stops** +**Stops**\\
 This filter allows you to display only those intervals at which there were stops or only those at which there were no stops. To do this, select either the //With stops// or //Without stops// option from the drop-down list. If the filter is not used, the report displays all the intervals, regardless of whether there were any stops or not. This filter allows you to display only those intervals at which there were stops or only those at which there were no stops. To do this, select either the //With stops// or //Without stops// option from the drop-down list. If the filter is not used, the report displays all the intervals, regardless of whether there were any stops or not.
  
-**Trailer** +**Trailer**\\
 Intervals filtration by the presence or absence of trailers assigned to the unit. Works similarly to the filtration by the driver. Intervals filtration by the presence or absence of trailers assigned to the unit. Works similarly to the filtration by the driver.
  
-**Trips** +**Trips**\\
 The filter allows you to display only those intervals that intersect with trips (it is not required for the entire trip to be a part of the interval) or only those that do not intersect with the trips. It is convenient to use the //Trips// filter, for example, in the report on geofences: in order to cut off excess visits to the same geofence during the unit's parking (when the coordinates are unsteady), select the //With trips// filter. The filter allows you to display only those intervals that intersect with trips (it is not required for the entire trip to be a part of the interval) or only those that do not intersect with the trips. It is convenient to use the //Trips// filter, for example, in the report on geofences: in order to cut off excess visits to the same geofence during the unit's parking (when the coordinates are unsteady), select the //With trips// filter.
  
-**Violation** +**Violation**\\
 The filter is available in the //Eco driving// table and allows to enter the name masks of the violations that are to be taken into account while generating a report. The filter is available in the //Eco driving// table and allows to enter the name masks of the violations that are to be taken into account while generating a report.
Follow us on Facebook Gurtam Wialon Twitter Gurtam Wialon info@gurtam.com   |   Copyright © 2002-2019 Gurtam