Click or drag to resize
Point table
Print this page

The Point table contains entries for each of the rows that appear in a vehicle list. These entries represent all of the valid points that have been received from the vehicle, across all of its operational statuses (driving, idling, or stopped).

Note Note

For field-level details, see the Point columns column descriptions and the Point diagnostics.

Retrieve Tips

The following tips can help you get the most out of your Point table queries:

  • By default, Point Retrieve templates are automatically sorted using the following logic: OrderBy = Input.UnitId, Input.Time. We recommend using the default ordering, because it is the most efficient and results in optimal performance.
  • To avoid issues when retrieving large numbers of points, use asynchronous mode by adding the ForceAsyncMode parameter to your query string.
  • By default, TDE filters out points that are teleported: these points are >=20 meters apart and would require a speed greater than 100 mph to be accurate. This filtering removes invalid points from the tracking units. You can retrieve such points by adding FilterTeleportedPoints = false in the [Template] section.
Requirements

When you write templates that access this table, follow these requirements:

  1. Specify the Symbolic Name for the table version to use:

    TableID = Point-2.0

  2. Specify an Intent that this table supports:

    • Retrieve
    • Create

  3. Input templates: In your [Output] section, be sure to map an input value to every table column that is flagged as being a primary key or required.

  4. Retrieve templates: This table requires the use of a fetcher. The following fetchers are available and are listed from most efficient to least:
    1. UnitId (Equals/In) AND Time (Between)
      [Filter]
      UnitId(ExternalIdName) = Equals("ABC123")  # You can either use the Equals function as shown
                                                 #   or use the In function: In([Id1,Id2,Id3])
      Time = Between(TimeStart,TimeEnd)          # Timestamp variables from User or Calculated section
    2. Time (Between)
      [Filter]
      Time = Between(TimeStart,TimeEnd)  # Timestamp variables from User or Calculated section
    3. Time (GreaterThan)
      [Filter]
      Time = GreaterThan(TimeStart)
    4. DriverId (Equals/In) AND Time (Between/GreaterThan)
      [Filter]
      DriverId = Equals(12345)                   # You can either use the Equals function as shown
                                                 #   or use the In function: In(["Id1","Id2","Id3"])
      Time = Between(TimeStart,TimeEnd)          # Timestamp variables from User or Calculated section.
                                                 # You can either use the Between Function as shown
                                                 #   or use the GreaterThan function: GreaterThan(TimeStart)
    5. Tag (Equals/In)
      [Filter]
      Tag = In(["Id1", "Id2", "Id3"])