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

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

   Copy

   TableID = Alert-1.0

2. Specify an Intent that this table supports:

   • Retrieve

3. Retrieve templates: This table requires the use of a fetcher. The following fetchers are available 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. TimeTriggered (Between/GreaterThan)

      You can improve the performance of the TimeTriggered fetcher by adding one or more of the following optional filter conditions: DriverId (Equals/In) , UnitId (Equals/In), TriggerValue (Equals/In), or ConditionId (Equals/In).

      Copy

      [Filter]
      TimeTriggered = Between(TimeStart,TimeEnd)  # Timestamp variables from User or Calculated section
                                                  # User either a GreaterThan or Between function
                                                  # like Between(TimeStart,TimeEnd)
      # Optional filters:
      DriverId(ExtId) = Equals("Id1")               # Equals or In   
      UnitId = Equals("MyCode1")                    # Equals or In  
      ConditionId(ExtId) = In("Id1", "Id2", "Id3")  # Equals or In
      TriggerValue(ExternalId) = Equals("Id1")      # Equals or In

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.

Additional columns: