Click or drag to resize
Team table
Print this page

The Team table allows you to manage teams for the organization of drivers.

Teams have two types:

  • Hierarchy teams are defined implicitly as a node in a hierarchy to enable users to work with vehicles and teams based on their position in the company's organizational structure. You can use the Fleet table to retrieve hierarchy teams. Use the Hierarchy table to create, update, or delete a hierachy team.
  • Explicitly created teams are useful for sharing information with customers or organizing information about drivers by some criterion other than your company's structure. You can use the Fleet table to create, update, delete, and retrieve non-hierarchical teams.

This topic contains the following sections:

Tip Tip

You can manage the drivers assigned to a team by using the Driver table.

Requirements

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

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

    TableID = Team-1.0

  2. Specify an Intent that this table supports:

    • Retrieve
    • Create
    • Update
    • CreateOrUpdate
    • Delete

  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.

Team Column Descriptions

This list includes each column's name, which you use in expressions to retrieve or create data, and data type, which defines how the data is retrieved and set.

Note Note
If a column of data type Id is a primary key OR if it refers to other tables (Id <OtherTable>), then you can map it to an external key or, in some cases, a Telogis key.
Column Data Type Description
Id Id (primary key) The ID of the team.
Name Text (Telogis key) The name of the team.
IsPublic BoolType Indicates if the team is public or private. Public teams are available to all users, while private teams are available to only their owner.
Notes Text Free form notes about the team.
IsHierarchy BoolType (read-only) Indicates if the team is a hierarchy team. Hierarchy team can only be edited by updating the hierarchy.
DriverIds Set<Id<Driver>> A set of driver IDs in the team. Updates must include the full set of desired IDs.
Custom columns
Column Data Type Description
Custom.name Text Specifies a user-defined custom column name to store additional information in the table. If the column name contains non-alphanumeric characters, enclose the value in brackets, for example Custom.[Special column].