JQL query to filter parent stories that contain "Sub Test execution" issuetype

[Olaf Stieber]

I am trying to figure out how to write a JQL query in jira /confluence that will filter  stories that contain a sub test execution issue type

Also I would like to create a separate query that would filter stories that do NOT contain a Sub test execution issuetype. 

This would allow me to report on IN SCOPE and OUT of scope stories for QA

[Ziad Bakhiet]

Hello Stieber,

You can get the results using JQL Search Extensions

You can find parents of subtasks with issue type "Sub Test execution" using the following JQL:

• issue in parentOf("issueType =Sub Test execution")

Then you can find the rest issues using the following JQL:

• issue in parentOf("issueType !=Sub Test execution")

You can find the full documentation here.

Regards,

Ziad

[Sudarshan]

Hello Olaf,
Welcome to the community.

You can try this JQL: (straight forward)

project = <Project name> AND issuetype = "Sub Test Execution"
This will give you all the "Sub Test Execution" items in your project.
to find to which story they belong to, check the summary and you will get the story.

The out of scope seems a bit tricky.!? :) 

You could tell what JQL you tried.?
for more detailed test reports you can try to add Xray Test management to your project (for manual and automated)
https://docs.getxray.app/display/XRAY/Overall+Requirements+Coverage+Gadget