How to use JQL to get a list of Xray tests from a list of stories attached to another parent issue?

Skye Booth

Hi there! 

I have a parent issue - RM-XXX

RM-XXX has many Stories and Bugs linked to it, and each Story or Bug has a linked Xray test.

I am struggling to find the JQL to pull a list of the Xray tests so that they can be exported. 

Overview of links:

- RM-XXX

     - Linked Story 1

          - Xray Test 1

     - Linked Story 2

          - Xray Test 2

I need a query to use to pull all of the Xray tests. 

 

I know that I can pull a list of the linked stories using: "issuekey in LinkedIssue("RM-XXX")", but I don't know how to go one step further to grab all of the Xray tests. 

 

I appreciate any feedback or help!! 

 

Jack Nolddor [Sweet Bananas]

Hi Skye,

Sadly you cannot achieve the desired search using standard features on Jira, you must go for a third-party app instead. Using i.e. JQL Booster Pack you can type the following:

 

First find the way to retrieve desired Stories, i.e.:

project = "My Project" and resolution IS EMPTY and issuekey in linkedIssues("RM-XX")

Then you can use this as a subquery on linkedIssuesOf() function as shown below:

 

type = "Xray Test" AND issue <span>IN</span> linkedIssuesOf(<span>' <em>project = "My Project" and resolution IS EMPTY and issuekey in linkedIssues("RM-XX")</em> '</span>)

Note that this is just an exaple, you must tune your query to fit your needs

Using this app you can also query other issues relations, check:

• epicsOf()
• hasSubtasks()
• issuesInEpics()
• linkedIssuesOf()
• parentsOf()
• portfolioChildOf()
• portfolioParentOf()
• subtasksOf()

 

References:

• Official documentation

 

Hope this helps you to create awesome queries

Kind regards