Click or drag to resize
Category table
Print this page

The Category table allows you to manage marker categories within Fleet and to access those categories by external key.

Marker categories represent important characteristics of locations, such as customer sites, prohibited locations, pick-up points, refueling stations, and so on. A marker can belong to more than one category. One of the categories a marker belongs to is identified as its primary category.

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 = Category-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"])
Category 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 category.
Name Text (Telogis key) The name of the category.
IsPublic BoolType Indicates if the category is public or private. Public categories are available to all users, while private categories are available to only their owner.
OnlyShowOwnMarkers BoolType True if the category restricts the visibility of its markers to only those owned by the current user.
HasDepot BoolType True if the category has a depot.
ListColor Color For displaying the vehicles list, specifies the background color for vehicles that are stopped at a marker in this category.
HistoryColor Color For displaying the history details list, specifies the background color for vehicles that are stopped at a marker in this category.
ReportColor Color For displaying report entries, specifies the color to use to highlight vehicles that are stopped at a marker in this category.
Icon Text Sets the system icon to display for this category. Enter a value 000 through 255 (referring to the order in the UI) or a named value (ex.: 'blue_tl' points top-left, 'green_d' points down).

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.
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].