Report Templates - v22-appfactory/appfactory-wiki GitHub Wiki

Workflow History Template

This sample template has a primary table [Workflow History] and four related tables:

  • Work Request
  • Workflow Actions
  • Workflow States : starting state
  • Workflow States : ending state

Work Request History Template : Table Relationships

Work Request History Template : Template JSON and Attribute Values

Template Attributes

Report Templates consist of a list of tables and table columns. The attributes provide table reference information that allow queries to link records based on table relationships. The template also defines a default set of columns that will be displayed and the column orders. The default column selections and order can be overridden when specifying the query. Any column in the template can be included in the query.

Table Attributes

  • id - the table ID
  • _comment - a name describing the table
  • related - a column ID that is used to link this table's ID to the specified column in the primary table

Table Column Attributes

  • id - the column ID
  • label - label used when displaying the column in the report query screen
  • _comment - a name describing the column
  • displayorder - the order that the column will appear in the default column selection list or 0 if not displayed by default
⚠️ **GitHub.com Fallback** ⚠️