Search for Test Tickets linked to Bugs and Stories when the Bugs and Stories are in the status of Do

[Marie]

 I'm searching for Test tickets that are linked to Bugs and Stories and the Bugs and Stories are in the done state. I can do it separately but am struggling on a combined JQL.

1) All Bugs and Stories that are in done state:, how I managed it so far:

project = A and issuetype in (story, bug) and status = Done and issueLinkType = "is tested by" 

2) Searching for the test tickets in the "To Do" state linked to the stories and Bugs:

project = A AND issuetype = Test AND status = "To Do" AND issueLinkType = "is a test for

I tried this, but it did not return anything and I know there is a lot that I should be getting:

(project = A AND issuetype in (Bug, Story) AND status = Done AND issueLinkType = "is tested by") and (issuetype = test and issueLinkType = "is a test for" and status= "To Do" )

[Ste Wright · Accepted solution]

Hi @Marie 

You'll need an App for this - such as Scriptrunner - which extends the functions of JQL to allow for sub-querying.

Sub-querying would allow you to set parameters for the linked issues.

Then if you wanted to find all the Tests, linked to done Bugs/Stories, you could use something like...

issueFunction in linkedIssuesOf("issuetype in (Story, Bug) AND status = Done", "is tested by") AND issuetype = Test

Ste

[Marie]

This is awesome!  Thank you so much.  Works like a charm!