Table provided time series data

The Table provided time series data rule enables you to select a table containing values with a DateTime data type, and specify the column that contains time series data.

Syntax

SELECT column FROM table WHERE where clause; TC=column; options and parameters

Arguments

• SELECT column

  If a column name contains non-alphanumeric characters, including spaces, it must be enclosed in [ ] brackets.

• FROM table

  If a table name contains non-alphanumeric characters, including spaces, it must be enclosed in [ ] brackets.

• WHERE clause

  Optional. For more information on WHERE clause syntax, see WHERE clause syntax.

• TC column

  Specifies the column that contains timestamp values. If a column name contains non-alphanumeric characters, including spaces, it must be enclosed in [ ] brackets.

• Options

  You can enter the following options in a list separated by semicolons.

  Stepped	When set to True, the returned value plots as stepped in applications.
  TZ=time zone	Not supported at the column level. You need to specify the time zone in the Time Zone field on the General tab for the overall table.
  UOM=uom	Specifies the unit of measure for the value returned by the result column. Note: You can also set the unit of measure in the table column definition, so that you do not need to specify it with each table lookup.
  RWM=value	Specifies the value to return when there is no column match. If the value is No Data, the digital state of No Data is returned.
  RWN=value	Specifies the value to return when the result column is null. If the value is No Data, the digital state of No Data is returned.

• Parameters

  You can enter parameters in a list separated by semicolons. Begin each parameter name with the @ character in @parameter=value format (value is described in "Attribute or Value" in WHERE clause syntax). For additional information on using parameters, see Parameters for linked table queries.

Example

In the following example,

SELECT [Installation Date] FROM location; WHERE RowID =@id; TZ=China Standard Time; TC=Installation Date