Is there a way to get the count of all test cases linked to the stories in a Sprint?

[Tushar Deherkar]

For the upcoming Sprint, I want to see the count of test cases linked to each story added so far to the Sprint. How can I get a table with all stories listed and the count of Test cases linked to them mentioned for each story?

[Hannes Obweger - JXL for Jira]

Hi @Tushar Deherkar

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a range of so-called smart columns that aren’t natively available (like the number of issue links), as well as various advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like the following in just a couple of clicks:

This is just one of a virtually endless number of possible reports - you can also group by any other field(s), configure different sum-up styles (like maximum, minimum, or average), etc. etc.

Any questions just let me know,

Best,

Hannes 

[Laurie Sciutti]

Hi @Tushar Deherkar and welcome to the Community!  I think you want the following, where your saved filter is a JQL for the sprint:

key in requirementTests('<saved filter name>')  

[Tushar Deherkar]

Thanks for the quick response @Laurie Sciutti ..

So, I created a filter with all current issues i.e. defects and stories in a Sprint to use with the syntax you gave but I don't see requirementTests function listed 

[Laurie Sciutti]

@Tushar Deherkar ~ I should have asked which Test Management app you are using...the example I provided was for XRay Test Management.

[Thammana, Sriraj]

Hi @Laurie Sciutti I am using XRay test management and i used your query and gives me list of test cases against a requirement. But i cannot find how many test cases are linked to each user story. is there a way to find out ?

[Laurie Sciutti]

Hello @Thammana, Sriraj and welcome to the Community!  The JQL I provided should return Tests associated with a Requirement (Story).

To find Tests associated with a single Story/Requirement, use this format where ABC-123 is the key of your Story/Requirement.

key in requirementTests(ABC-123)

To find Tests associated with multiple Stories/Requirements, first create a filter of the Stories/Requirements and then use the format below to embed your filter.

key in requirementTests('<saved filter name>')

[Thammana, Sriraj]

Hi @Laurie Sciutti Thx for your reply, i tried above steps and create a filter with my project name and type= story. Then used below query to get the count of test cases for each story but this still gives me only view of test cases from my saved filter but not the count of test cases against each story.

I am looking only for count of test cases against each story.

key in requirementTests('<saved filter name>')

[Tushar Deherkar]

@Laurie Sciutti , I'm not using Xray or any other test management tool. Is there any workaround in that case?

[Thammana, Sriraj]

@Tushar Deherkar May i know how are you maintaining the test cases if there is no tool or plug ins ?