Prerequisites
- Both entity types must already exist in your
domainModelTypessection (see Create an Entity Type) - A Polarion link role must be configured in your project for the relationship
- Basic familiarity with the data model
relationshipsarray (see Configure a Relationship)
Define Both Navigation Directions
direct and back properties. The direct direction navigates from the from entity to the to entity. The back direction navigates in reverse — from to back to from.Add a relationship entry with both direct and back names defined:Choose the Right Cardinality
Many-to-One Example
EachUserNeed belongs to exactly one Chapter:- The
directpropertychapteris singular — it returns oneChapterentity - The
backpropertyuserNeedsis plural — it returns a collection ofUserNeedentities
Many-to-Many Example
UserNeed links to multiple SystemRequirement items and vice versa:Use Bidirectional Links in Sheet Sources
UserNeed to SystemRequirement):SystemRequirement to UserNeed):Bind Columns to Both Directions
SystemRequirement):UserNeed):navigationProperty.targetEntity.field. For many-to-one relationships, the binding is simpler since the property is scalar:Build a Multi-Level Hierarchy
UserNeed → SystemRequirement → DesignRequirement — or traverse it in reverse from any level using the back navigation properties.Verify Your Bidirectional Links
- Open the Model Helper widget in your Polarion project
- Set the depth parameter to at least 2 to see multi-level relationships
- Confirm that each entity type shows both its
directandbacknavigation properties - Open a sheet that uses the data model and expand a row — you should see child items loaded through the navigation property
- Switch to a sheet using the reverse direction and verify the
backproperty loads the expected parent items
UserNeed shows its linked SystemRequirement items, and expanding a SystemRequirement shows the UserNeed items that reference it.Common Pitfalls
The sources.model property must match your data model name
The sources.model property must match your data model name
sources.model property in your sheet configuration matches the custom model name defined in your YAML file, not the default rtm. A mismatch causes model connection errors.See Also
- Configure a Relationship — core relationship setup
- Configure Many-to-Many Relationships — association entity patterns and advanced M:N configuration
- Add a Column — column binding path syntax
- Expand Navigation Properties — query-level navigation property expansion
- Use Model Helper Widget — visual model verification tool
- Data Model Reference — full property reference for relationships