I'm looking for a JQL to display stories that do not have test cases linked to them (traceability)

[Jeroen Bossuyt]

Every time we create a test case, we immediately make sure it is linked to a story. When I open the story in the active sprint, I can see which test cases are linked in the "traceability" part of the story.

Now I'm looking for a JQL to make a quick filter that makes sure only the stories that do not have at least 1 test case linked to them are visible.

Could anybody help with that?

Thanks in advance!

[fran garcia gomera · Accepted solution]

with scriptrunner you have the hasLinks issueFunction

issueFunction not in hasLinks("[link name]")

You have all the info in

https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_haslinks

[Jeroen Bossuyt]

Thank you for your swift response!

One more question: what exactly do I replace "link name" with in order to find any test cases? I have tried some things, but can't seem to get it to work.

Thanks!

[fran garcia gomera]

which case test manager are you using? probably I misunderstood your question.

[Jeroen Bossuyt]

We're using Adaptavist for our test cases, but while looking for a way to do it with your script, we found a working solution.

We used this to get it to work:

issue not in hasTestCoverage()

[fran garcia gomera]

Nice, glad that it helped in any way.

[Anand S Koshy]

@Jeroen Bossuyt  this worked 

[Anand S Koshy]

@fran garcia gomera  & @Jeroen Bossuyt 

I found out a way to filter issues where there is a test case attached, but to go a level further, would there be a way to filter out approved test cases from the issues where test cases are attached. We use Zephyr. 

issue in hasTestCoverage()

[Veronika S.]

Is there any possibility for Jira Cloud users with Zephyr Scale Tests?

[Anand S Koshy]

We’re you able to find an answer for this ?

[Anand S Koshy]

This works for zephyr as well 

issue not in hasTestCoverage()