JQL query to see all Tests which are linked to all Stories in current Sprint

[SchuriiK]

Hi guys,

I need a JQL filter to see all tests which are linked to the stories in the current sprint.

I'd appreciate any help! Thanks in advance.

Best regards

Alex

[Thomas Magny-Garcia · Accepted solution]

Hi @SchuriiK 
I think a query like that should help you, it gives all issues whose the type is Test and with linked issues whose the Srpint is SprintID and the type is Story.

issuetype = Test and issueFunction in linkedIssuesOf("issuetype = Story and Sprint = SprintID")

Hope it helps !

[SchuriiK]

Hi @Thomas Magny-Garcia

it works like a charm! Thank you so much! :)

[Pankaj Kumar]

It doesn;t work for me. JQL gives me error saying issueFunction doesn't exist.

[Alan W_ Yueh]

You probably need the ScriptRunner plugin.

[Muhammad Waqas Osmani]

Hi,

Just want to ask is there anyway to achieve aforesaid without using script runner plugin.

[DTS Infra Admin]

How can this be achieved without using script runner plugin?

[sinhshi]

And how should we get this like:

Story1 has 5 test a,b,c

Story 2 has 3 tests like f,g,h

so and so...

View should be :

---

Story1|| A

         || B

       ||C

Story2  ||F

      ||G 

||H 

and so on..

[sinhshi]

Have solved this issue by use of Structure in Jira

[Dave Rosenlund]

Very glad to hear this, @sinhshi. Congratulations.

Perhaps you'd be willing to share some insights about your journey between May 11th and June 15th so others will benefit from your experience.

Full disclosure, I work for the company that makes Structure by Tempo, but I truly believe others might benefit from your story regardless of the product you chose.

-dave

[sinhshi]

Maybe this link will help : https://youtu.be/VNXG5tGkHqs