Click or drag to resize
Tag table
Print this page

The Tag table provides information about the tags defined for a Fleet customer account.

Tags are keywords that can be assigned to vehicles, drivers, and sites. Typically, tags represent special skills or properties that might be required for certain jobs. Tags can also be used to group vehicles, drivers, or sites into custom categories.

To Create a Tag, you must provide a unique Name. A unique Tag Id is generated automatically when the tag is created.

To Delete or Update a tag, only the Id is required.

This topic contains the following sections:

Requirements

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

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

    Copy
    TableID = Tag-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.

  4. Retrieve templates: This table does not require the use of a fetcher. However, the following fetchers are available to optimize your query and are listed from most efficient to least:
    1. Id (Equals/In)
      Copy
      [Filter]
Id(ExtId) = Equals(Id1)   # You can filter on literals or on variables from the [User] or [Calculated] sections.
      Copy
      [Filter]
Id(ExtId) = In(["Id1","Id2","Id3"])
    2. Name (Equals/In)
      Copy
      [Filter]
Name = Equals(Name)
      Copy
      [Filter]
Name = In(["Name1","Name2","Name3"])
Tag 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 tag.
Name Text The name of the tag.

Additional columns:

Column Data Type Description
CustomerId Id (read-only, all Fleet tables) The ID of the customer/owner.
CustomerFullName Text (read-only, all Fleet tables) The human-readable full name of the customer/owner.