AncestorAlias

The AncestorAlias () text function is used to return the value of a given attribute-name returned from the relational table query. This function is valid for relational tables.

Syntax

AttributeAlias("TableName", "AttributeName", row-reference,)

Parameters

TableName - this is an optional parameter if the text function is used in a text cell of the relational table. If the text function is used in a Text object, the table-name parameter is optional if there is only a single relational-table in the report, otherwise the table-name parameter is required.

AttributeName - this is the attribute-name is a required parameter. This attribute-name must correspond to an attribute-name along the column axis of the relational-table, or on the POV of the relational table.

row-reference - this is an optional parameter. If no row-reference parameter is given and the attribute-value text function occurs in a text cell of a relational-grid, the 'current' row in the relational table is used. If the attribute-value text function occurs in a text object, and the attribute-name is on the column-axis, the row-reference is required. The row reference can include an offset (eg: a row-reference of 1(5) will return the attribute-value for the 5th tuple in row 1).

Note:

  • If the attribute-value function does not have a table-name parameter and occurs in a text object, and there are two or more relational-tables, a validation error occurs.
  • If the attribute-name parameter is not on the column axis or pov, or if the only occurrence is within an aggregate function (eg: Count(), Max(), etc), a validation error occurs.

Example

  • AttributeValue("Artifact Actions.User"): will return the attribute-value for the given attribute-name in the current row of the relational table, or the attribute-value of the given attribute-name on the POV.
  • AttributeValue("Artifact Actions.User", 1(5)): will return the attribute-value for the given attribute-name in the 5th row of the relational table. This syntax is not valid if the attribute-name is on the POV. A validation error will occur. If the relational-table resultset does not have 5 rows, an empty string will be returned.
  • AttributeValue("Table 1", "Artifact Actions.User", 1(5)):
  • AttributeValue("Table 1", "Artifact Actions.User", 1(5)): will return the attribute-value for the given attribute-name in the 5th row of the specified relational table. This syntax is not valid if the attribute-name is on the POV. A validation error will occur. If the relational-table resultset does not have 5 rows, an empty string will be returned.