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:
- 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!!
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 IN linkedIssuesOf(' project = "My Project" and resolution IS EMPTY and issuekey in linkedIssues("RM-XX") ')
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:
Hope this helps you to create awesome queries <3
I was able to use the following steps to get what I needed with the available JQL in our instance of JIRA:
1. run an initial query to return all of the stories that I needed to pull the Xray tests from:
issue in linkedIssues("RM-960")
2. Save this as a filter. I called it "RM-960 Stories"
3. Run a second query to get all of the Xray tests linked to the stories in the filter that I just saved
key in requirementTests("RM-960 Stories")
4. Add the Manual Test Steps (Export) column
5. Export at the top right in preferred way
this used to work for me but we went to the cloud version over the weekend, now this won't work... and it seems that the 'requirementTests' function does not work...
can anyone help?
i have spent a day+ looking for why this won't work for me, or a work around.
Currently, it is not possible to have Xray's JQL functions, due to the Cloud Architecture, which doesn't allow us access to the Jira Database, stopping us from creating JQL functions.
This is why the JQL functions we provide in Xray Server are not available in Xray Cloud.
If you need further help, please contact the Xray Support (http://xraysupport.xpand-it.com).
Rogério Paiva [Xray Support Team]
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events