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?
Hi @Tushar Deherkar and welcome to the Community! I think you want the following, where your saved filter is a JQL for the sprint:
in requirementTests('<saved filter name>') key
in
requirementTests(
'<saved filter name>'
)
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
@Tushar Deherkar ~ I should have asked which Test Management app you are using...the example I provided was for XRay Test Management.
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
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 ?
It looks like you're new here. Sign in or register to get started.