Link Role Property Reference
How Link Roles Bridge the Data Model and Polarion
- Read operations: Powersheet queries Polarion for work items connected via the specified link role, then populates the sheet with the results.
- Write operations: When users create or remove links in the sheet, Powersheet uses the same link role to persist changes to Polarion.
Where linkRole Appears in Configuration
The linkRole property is specified on each entry in the relationships array of the data model YAML. It sits alongside the structural properties (from, to, cardinality, storage) and the navigation direction definitions (direct, back).
Context Within the Relationship
Link Role and Relationship Direction
A Polarion link role is inherently directional: it has a “from” side and a “to” side. The data model’sfrom/to entity types and direct/back navigation properties align with this directionality.
The
isBacklink flag is managed internally by the system. When Powersheet processes a back direction, it internally flags the reverse traversal so that Polarion queries use the correct link direction.
A single
linkRole value serves both the direct and back navigation properties. You do not need to define separate link roles for forward and reverse traversal. Powersheet handles the directionality automatically based on the direct/back configuration.Link Role and Cardinality Interaction
ThelinkRole itself does not encode cardinality — it is a simple identifier pointing to a Polarion link role. Cardinality is controlled separately by the cardinality property. However, the combination of linkRole and cardinality determines the runtime behavior:
See Cardinality for the full reference on each value and its effects across model, source, and column layers.
Reusing the Same Link Role
A single Polarion link role can appear in multiple relationships. This is common when the same semantic relationship type applies to different entity type pairs.decomposes link role is reused across two relationship definitions. Each relationship has its own from/to pairing and its own navigation property names, but they share the same underlying Polarion link role.
Permission Control on Relationships
Relationships support permission flags that control whether the link role’s operations are available through the sheet:
Individual navigation properties (
direct and back) can also have independent permission settings, allowing fine-grained control over which direction of a link role is editable or visible.
Validation Rules
Powersheet enforces specific rules when processinglinkRole values:
Complete YAML Example
A minimal data model demonstratinglinkRole across different relationship types:
parentfor the hierarchicalUserNeedtoChapterrelationship (many-to-one)decomposesfor the traceabilitySystemRequirementtoUserNeedrelationship (many-to-many)
storage: linkedWorkItems and defines both direct and back navigation properties for bidirectional traversal.
Related Pages
- Relationships — complete relationship definition reference
- Cardinality — relationship multiplicity options and their effects
- Navigation Directions —
directandbacknavigation property definitions - Constraints — filtering constraints on navigation directions
- Permissions — CRUD permission controls on relationships and properties
- Polarion Type Mapping — entity type to work item type mapping
- Binding Syntax — using navigation properties in column bindings
- Sources — configuring expand paths that reference navigation properties