Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL to display all test cases linked to stories in the current sprint

I need to create a JQL filter to display all test cases linked to stories in the current sprint. While I know there is an answer to this if you have the ScriptRunner plugin but I don't have it and, because I'm in a large corporate, they have decided they do NOT want to install it (sigh).

So, anyone got any ideas how to do this, I'm all out. Potentially it does not have to be one filter, perhaps a filter of a filter.

Ideas?

2 answers

If the test cases are a separate issues type you can query for the links using a query like this:

Project = XYZ and issueLinkType in (blocks, causes)

This is available in Jira starting at version 8.0. 

We have JIRA Version 8.5.7 and the search doesn't work for me, "causes" is not found. We are using Test Management for JIRA v6.7.4 (TM4J). Since I'm trying to effectively display a list of test cases that are linked to stories in the current sprint, I feel that I need to search from TM4J to get the list. However, TM4J's search does not seem to have any sophisticated search ability to allow me to select test cases that are linked to stories in the current sprint.

If I go to reports in TM4J, there are multiple reports but there does not seem to be a way to say, "only show me the test cases that are linked to stories in the current sprint". The conditions that are presented don't seem to cover that scenario.

0 votes

I'm not familiar with TM4J. Please explain how does it manage those testcases. Are they subtasks? Are they tasks linked to the issue you want to test? Are they a fancy and uber complicated custom field within the issue itself?

If there's any hope of finding the right JQL (and that isn't granted by any means) we'll need to know the structure of the information we want to query.

TM4J is Test Manager 4 Jira by Smart Bear. As far as I can tell, test cases are not issues but test cases in a different section. It even creates a new tab at the top called Tests. From a Story, you can see it's created a section called Traceability and under that Test Cases, Test Cycles and Test Plans.

Under the Tests menu at the top you then switch the display to only look at Test Cases/Plans/Cycles.

TM4J is similar in some regards to Zepher in that it also does test cases and testing. Personally, I think Zepher is better but we don't have it so all I can use is TM4J.

Does this help?

Somehow, but if anything it tells me the plain JQL approach might be tricky if not impossible... :(

In the new tab it creates do you have some field you can identify as a custom field?? Maybe that plugin creates a bunch of custom fields and also custom view screens.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you