The Alert table allows you to retrieve InSight Alerts that have been triggered on a Fleet customer account.
This topic contains the following sections:
When you write templates that access this table, follow these requirements:
Specify the Symbolic Name for the table version to use:
TableID = Alert-1.0
Specify an Intent that this table supports:
[Filter] Id(ExtId) = Equals(Id1) # You can filter on literals or on variables from the [User] or [Calculated] sections.
[Filter] Id(ExtId) = In(["Id1","Id2","Id3"])
You can improve the performance of the TimeTriggered fetcher by adding one or more of the following optional filter conditions: DriverId (Equals/In) , UnitId (Equals/In), TriggerValue (Equals/In), or ConditionId (Equals/In).
[Filter] TimeTriggered = Between(TimeStart,TimeEnd) # Timestamp variables from User or Calculated section # User either a GreaterThan or Between function # like Between(TimeStart,TimeEnd) # Optional filters: DriverId(ExtId) = Equals("Id1") # Equals or In UnitId = Equals("MyCode1") # Equals or In ConditionId(ExtId) = In("Id1", "Id2", "Id3") # Equals or In TriggerValue(ExternalId) = Equals("Id1") # Equals or In
This list includes each column's name, which you use in expressions to retrieve data, and data type, which defines how the data is retrieved.
|Id||Id||(primary key) The ID of the alert.|
|ConditionId||Id<Condition>||The ID of the condition that generated this alert.|
|TimeTriggered||Timestamp||The time that this alert was triggered.|
|TimeOn||Timestamp||The time the alert came on. This is the time of the first report that indicated the alert condition.|
|TimeOff||Timestamp||The time the alert was turned off. This is the time of the first report that indicated the exception was no longer occurring.|
|DriverId||Id<Driver>||The ID of the driver that was assigned to the vehicle when the alert was triggered.|
|UnitId||Id<Unit>||The ID of the vehicle that triggered the alert.|
|MarkerId||Id<Marker>||The ID of the marker that was involved in the alert, if any.|
|JobId||Id<Job>||The ID of the job that was involved in the alert, if any.|
|Address||Address||The address at which the alert occurred.|
|Speed||Speed||The speed of the vehicle at the time the alert triggered.|
|SpeedLimit||Speed||The speed limit where the alert triggered.|
|TriggerName||Text||The name of the diagnostic parameter that triggered the alert.|
|TriggerValue||Text||The diagnostic parameter value that triggered the alert.|