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

[P Merrill]

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?

[Iago Docando]

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.

[P Merrill]

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?

[Iago Docando]

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.

[Stephen Garber]

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. 

[P Merrill]

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.