Click or drag to resize
DataType table
Print this page

The DataType table allows you to retrieve information about the Data types that are used by TDE.

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:

    TableID = DataType-1.0

  2. Specify an Intent that this table supports:

    • Retrieve

  3. 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)
      [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"])
DataType column descriptions

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.

Column Data Type Description
Id Id (primary key) The ID of the data type.
Name Text (Telogis key) The name of the data type.
IsMeasurement BoolType Indicates whether this data type is a measurement. Measurements are scalar values which can be expressed in multiple different units.
ReferenceMeasurementUnitId Id<MeasurementUnit> All other units of measurement of this data type are stored relative to this MeasurementUnit.
IsEnum BoolType Indicates whether this DataType is a type of EnumType.
EnumValues Set<Text> The set of acceptable values for this DataType if this is an EnumType.
GenericTypeParameterIds Array<Id<DataType>> For DataTypes that extend a generic type, provides the list of DataType IDs that this DataType uses. For example, the Array<TimeInterval> DataType uses the TimeInterval DataType.
BaseTypeId Id<DataType> If an ID is listed, then this DataType is based on the abstract DataType indicated. For example, the base type of the Array<TimeInterval> DataType is Array<>.
IsAbstract BoolType True if this DataType is abstract (like Array<> or Set<>), and false if it is not (like Array<TimeInterval>).