Function GETRELATIONSHIPVALUE()

Description
Returns a specific relationship attribute value between two items.

Syntax

GETRELATIONSHIPVALUE(item1Identifier, item2Identifier, codeValue)
GETRELATIONSHIPVALUE(item1Identifier, item2Identifier, codeValue, type)

Parameters

• item1Identifier – First item (name, internal ID, external ID, or expression)
• item2Identifier – Second item (same rules as item1)
• codeValue – Relationship attribute or calculated value to return
• type (optional) – name (default), internalid, or externalid

Return Value
Varies (NUMBER, TEXT, DATE, BOOLEAN, ARRAY) or NULL if not found

Examples

Formula

GETRELATIONSHIPVALUE("TEAM1", "SPRINT3", "capacity")

Result
Returns the capacity value between TEAM1 and SPRINT3

Formula

GETRELATIONSHIPVALUE(
  LOOKUP(GETRELATEDCATEGORY("Team","internalid"), 0),
  LOOKUP(GETRELATEDCATEGORY("Sprint","internalid"), 0),
  "capacity",
  "internalid"
)

Result
Returns capacity using internal IDs

Formula

IF(ISNULL(GETRELATIONSHIPVALUE("A","B","attr")), 0, GETRELATIONSHIPVALUE("A","B","attr"))

Result
Returns 0 if no value exists, otherwise the attribute value

Notes

• Defaults to name lookup unless type specified
• Returns NULL if no relationship or attribute exists
• Works on relationship-level data (not item attributes)
• Use ISNULL/IF to handle missing values