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 table row count from a Request context:
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.