Function GETRELATIONSHIPVALUES()

 

Description
The GETRELATIONSHIPVALUES function returns the values stored on relationships connected to a specified item or set of items. It is used to retrieve relationship attributes, properties, or calculated values for further analysis.

Syntax

GETRELATIONSHIPVALUES(itemIdentifier, codeValue)

GETRELATIONSHIPVALUES(itemIdentifier, codeValue, type)

 

Parameters

• itemIdentifier – An ARRAY of item names, Internal IDs, or External IDs for which relationship values are retrieved. Name is assumed unless specified in the type parameter.
• codeValue – The code name of the relationship property, attribute, or calculated value to return.
• type (optional) – A TEXT parameter specifying the identifier type. Valid values are:
• name
• externalid
• internalid
  If unspecified or incorrect, name is assumed.

Return Value
Returns an ARRAY of values. The data type depends on the codeValue and may be TEXT, NUMBER, DATE, or ARRAY.

 

Examples

Formula

SUM(GETRELATIONSHIPVALUES(RELATEDITEMS(), 'num'))

Result
Returns the sum of all relationship values (num) connected to the item, regardless of direction.

Formula

SUM(GETRELATIONSHIPVALUES(RELATEDITEMS('', FALSE, TRUE, FALSE, FALSE), 'num'))

Result
Returns the sum of all relationship values (num) that point towards the item.

Formula

SUM(GETRELATIONSHIPVALUES(

  INTERSECT(RELATEDITEMS(), WHERE(category == 'Projects')),

  'num'

))

Result
Returns the sum of all relationship values (num) for items in the Projects category.

Notes

• Available in SharpCloud version 9.7.0217 and later
• itemIdentifier and codeValue can be passed via attributes or calculated values
• If multiple items share the same name or External ID, results may be unpredictable
• Relationship values are added to both ends unless filtered