MeasurementUnit table

The MeasurementUnit table allows you to retrieve information about the units that can be used to measure Data types.

This topic contains the following sections:

Requirements

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

Specify the Symbolic Name for the table version to use:
Copy
```
TableID = MeasurementUnit-1.0
```
Specify an Intent that this table supports:
- Retrieve
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"])

MeasurementUnit 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 this measurement unit.
DataTypeId	Id<DataType>	The ID of the DataType that this unit is measuring.
Name	Text	The name of this unit of measurement, e.g. Miles.
Abbreviation	Text	The abbreviated name of this unit of measurement, e.g. mi.
Scale	Number	The scale of this unit of measurement. This defines how the magnitude of the unit compares to other units.
Offset	Number	The offset of this unit of measurement. defines how the scale of the unit is offset from other units.