Help Contents
-
Getting Started
-
Installation and Upgrade Guide
-
Administrator Guide
-
User Guide
-
Duette User Guide
-
Searching & TQL
-
Simple Search
-
Advanced Search
-
Testing Query Language (TQL)
-
Aggregation
-
Fields
-
Accumulated Actual Duration
-
Actual Duration
-
Affected Version
-
Agile Runs Count
-
All Packages
-
AllParents
-
Assigned To
-
Assignee
-
Assignment
-
Assignment Id
-
Assignments Count
-
Attachment Count
-
Automated Tests Count
-
Blocked
-
Change Comment
-
Comment
-
Component
-
Created At
-
Created By
-
Description
-
Destination
-
Difficulty
-
Difficulty Level
-
Directly Related To
-
Editor
-
Editors
-
Entity Type
-
Errors
-
Estimated Duration
-
Estimated Less Actual Duration
-
Execution Totals
-
Failed
-
Fields / Organisation
-
Fields / Package
-
Fields / Project
-
Fields / Relationship
-
Fields / Relationships
-
Fields / Relationship Type
-
Fields / Script
-
Finished At
-
Fixed Version
-
Has Agile Runs
-
Has Assignments
-
Has Attachments
-
Has Automated Tests
-
Has Coverage
-
Has Incidents
-
Has Requirements
-
Has Scripts
-
Id
-
Imported At
-
Incident Count
-
In Progress
-
Iterations
-
Key
-
Last Comment
-
Last Synchronized At
-
Last Updated At
-
Last Updated By
-
Name
-
Notes
-
NotRun
-
Number
-
Objective
-
Order Number
-
Parent
-
Parent And This Package
-
Parent Package
-
Passed
-
Post Condition
-
Pre Condition
-
Priority
-
Provides Coverage
-
Query
-
Raised By
-
Related To
-
Related To All Packages
-
Related To All Parents
-
Related To Entity Type
-
Related To Fields
-
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 Depth
-
Relationship Direction
-
Relationship Id
-
RelationshipTypeKey
-
Remaining Estimate
-
Requirements Count
-
Resolution
-
Run By
-
Run Number
-
Script Id
-
Script Priority
-
Script Status
-
Script Step Count
-
Script Type
-
Skipped
-
Source
-
Started At
-
Status
-
Step Actual Results
-
Step Data
-
Step Description
-
Step Expected Result
-
Step Notes
-
Summary
-
Test
-
Test Id
-
Test Scripts Count
-
Text
-
Ticket Id
-
Ticket Key
-
Ticket Url
-
Total Nodes
-
Total Results
-
Tracker
-
Type
-
Undetermined
-
Version Number
-
Warnings
-
Accumulated Actual Duration
-
Functions
-
Indexes
-
Operators
-
Order By
-
SET
-
TQL For JQL Users
-
Types
-
Values
-
Aggregation
-
Simple Search
-
API
-
Troubleshooting
-
Latest Version of this Documentation
Field: DirectlyRelatedTo
Description
DirectlyRelatedTo provides an easy way to filter entities based on the results of another query, representing the entities they are directly related to (so any indirect relationships an entity may have i.e. bugs associated with a requirement via script references) will not be included.
To better illustrate this, imagine we have a query representing all the high-priority requirements:
EntityType = Requirement AND Priority = High AND Project = 'Project X'
If we then wanted to find all scripts related to those high-priority requirements, we could use the DirectlyRelatedTo Field like this:
EntityType = TestScript AND RelatedTo IN { EntityType = Requirement AND Priority = High AND Project = 'Project X' }
Notice we have surrounded the original query for requirements within curly braces - this is know as a "sub-select" - it means we will execute the query within the curly braces first, then use the results of that query to filter the outer query.
If you only wish to match both direct and indirect relationships, use the field RelatedTo instead.
To perform more complex relationship queries, use the Relationships field.
Examples
All scripts related to low-priority requirements:
EntityType = TestScript AND RelatedTo IN { EntityType = Requirement AND Priority = Low AND Project = 'Project X' }
To find all scripts that have a direct relationship to a requirement with a name that includes customer:
EntityType = Script AND DirectlyRelatedTo IN {EntityType = Requirement AND Name ~ customer}
See Also
Supported Operators
Supported Indexes
Supported Types
- AgileRun
- AutomatedTest
- AutomatedTestAssignment
- Incident
- Requirement
- RequirementPackage
- TestExecutionPackage
- TestScript
- TestScriptAssignment
- TestScriptPackage
Supported Features
Feature | Supported? |
---|---|
Aggregation | No |
Sortable | No |
Sub-selects | Yes |