Share this page

# 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: