The relationships index is the an index that contains a flatted lists of all point-to-point relationships between entities.
The index is composed of the set of relationships visible from the "Relationships" tab of the edit screen for each entity, this allows for complex queries to be constructed where both direct and indirect relationships can interrogated.
To begin filtering your query based on the relationships an entity may have, you need to use one of the following fields:
Examples
All requirements which are associated with open bugs:
EntityType = Requirement AND Relationships IN { RelatedToEntityType = Incident AND RelatedToStatus = Open }
See the Relationships topic for more examples of querying relationships using this index.
Fields
- All Packages
- All Parents
- Destination
- Entity Type
- Id
- Organisation
- Package
- Parent
- Project
- Related To All Packages
- Related To All Parents
- Related To Entity Type
- Related To Id
- Related To Organisation
- Related To Package
- Related To Parent
- Related To Priority
- Related To Project
- Related To Status
- Related To Type
- Relationship
- Relationship Depth
- Relationship Direction
- Relationship Id
- Relationship Type
- Relationship Type Key
- Source