Filtering results through nested JQL query with ScriptRunner

[Alexander Jancauskas]

Hey there,

in our Jira projects we have tickets of the type Feature and of the type Test. Tests are linked to Features via a "tests / is tested by" link. Now in our CI Pipeline in Bamboo, we want to execute a certain set of Tests which can be characterized like this:

• All Tests with "status = 'In Use'" that are linked against one or more Features of which at least one has "status = Done"

I want to create this set of Tests as a filter in Jira. We have ScriptRunner installed, so I'm trying to create a nested query for this, but I just can't wrap my head around how to do this.

Can anyone maybe point me in the right direction?

Thank you in advance!

Alex

[Leonard Chew · Accepted solution]

Hi @Alexander Jancauskas 

Try this

issuetype = Test and status = 'In Use' and issueFunction in linkedIssuesOf('issuetype=feature and status=Done','is tested by')

I hope I got all the values right. 

[Alexander Jancauskas]

Works like a charm, thank you so much for taking the effort! I was thinking way too complicated, ha :D