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

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

   Copy

   TableID = DriverAssignment-1.0

2. Specify an Intent that this table supports:

   • Create
   • 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. Driver (Equals) and From (Between)
      Copy

      [User] # Set via query string: &DriverId=123&Start=2013-02-01&End=2013-03-01
      DriverId = ""
      Start(Timestamp) = ""
      End(Timestamp) = ""
      
      [Filter]
      DriverId(ExternalIdName) = Equals(DriverId)
      From = Between(Start, End)

   3. Driver (Equals)
      Copy

      [User] # Set via query string: &DriverId=123
      DriverId = ""
      
      [Filter]
      DriverId(ExternalIdName) = Equals(DriverId)

   4. From (Between)
      Copy

      [User] # Set via query string: &Start=2013-02-01&End=2013-03-01
      Start(Timestamp) = ""
      End(Timestamp) = ""
      
      [Filter]
      From = Between(Start, End)

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.