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

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

   Copy

   TableID = Timesheet-1.0

2. Specify an Intent that this table supports:

   • Retrieve
   • Create
   • CreateOrUpdate
   • Update

3. Input templates: In your [Output] section, be sure to map an input value to every table column that is flagged as being a primary key or required.

4. 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. ShiftTime (Between) AND DriverId (Equals)
      Copy

      [Filter]
      ShiftTime = Between(TimeStart,TimeEnd)           # can use variables from [User] or [Calculated]
      DriverId(ExternalIdName) = Equals("DOE123")      # or use Telogis Id: DriverId = Equals("123456...")

   3. ShiftTime (GreaterThan) AND DriverId (Equals)
      Copy

      [Filter]
      ShiftTime = GreaterThan(TimeStart)
      DriverId(ExternalIdName) = Equals(userinput_id)  # or use Telogis Id: DriverId = Equals("123456...")

   4. ShiftTime (GreaterThan)
      Copy

      [Filter]
      ShiftTime = GreaterThan(TimeStart)

This list includes each column's name, which you use in expressions to retrieve or create data, and data type, which defines how the data is retrieved and set.

Note
If a column of data type Id is a primary key OR if it refers to other tables (Id <OtherTable>), then you can map it to an external key or, in some cases, a Telogis key.

Additional columns: