Tokens in Request Table Components
To refer to items in a table component, tokens must follow specific formats. The formats used depends on the table item referenced. Figure 4-3. Table component formats shows the basic elements of a sample table. These elements are used as examples for referencing data within the table using tokens.
Figure 4-3. Table component formats
The format [REQD.T.<
TABLE_TOKEN>]
is used to represent the table. The format [REQD.T.<
TABLE_TOKEN>.<
SPECIFIC TOKENS>]
is used to represent specific tokens. The following sections provide examples of the formats used for tokens that reference items related to the table component:
-
To access the Salary Column Total value from a Request context:
-
To access the Name of the first employee in the table from a Request:
-
To access the Code of the first employee in the table from a Request:
-
To access the Department Cell value of the current row (Table Row Context):
-
To obtain a delimited list of a column's contents (Request Context):
In these examples, a table component named Employee has the following four columns:
-
Employee Name
-
Years of Service
-
Department
-
Employee Salary
These columns are defined as follows:
Table Component "Employee" table with [EMPLOYEE] as the Token. Column 1 - Employee Name; Token = [NAME] Column 2 - Years of Service; Token = [YEARS_OF_SERVICE] Column 3 - Department; Token = [DEPARTMENT] Column 4 - Employee Salary; Token = [SALARY]
To access the table row count from a Request context:
[REQD.P.EMPLOYEE] - returns the raw row count without any descriptive information.
[REQD.VP.EMPLOYEE] - returns the row count with descriptive information. Example "13 Entries".
WHERE: EMPLOYEE is the Token given to a table component type.
To access the Salary Column Total value from a Request context:
[REQD.T.EMPLOYEE.TC.VP.SALARY.TOTAL]
WHERE: EMPLOYEE is the Token given to a table component type and SALARY is the Token name given the table's first column.
To access the Name of the first employee in the table from a Request:
[REQD.T.EMPLOYEE.TE="1".VP.NAME]
To access the Code of the first employee in the table from a Request:
[REQD.T.EMPLOYEE.TE="1".P.NAME]
To access the Department Cell value of the current row (Table Row Context):
[TE.VP.DEPARTMENT]
You can use this table component token in a Table Column Header validation SQL or in a table component rule SQL.
To obtain a delimited list of a column's contents (Request Context):
[REQD.T.EMPLOYEE.TC.VP.NAME]
where EMPLOYEE
is the token given to a table component type and SALARY
is the token name given the first column of the table. This is very useful if a column lists user names. This list can be used to send the users notification.