Only show Issues that have Sub-tasks with specific Summary

[Steffen Jantke]

Hi everyone,

I'd like to filter for all issues that don't have sub-tasks which contain a specific summary text. This is, what I've got so far:

project = XXX AND issuetype = "Story (Development)" AND status in (Resolved, Closed) AND resolution in (Done, Fixed) AND issueFunction not in hasSubtasks() ORDER BY priority ASC, "Epic Link" ASC, summary ASC

It's allowed to have sub-tasks with other summaries; I don't care about these. In my case, they should contain the summary text "Deployment":

issueFunction not in subtasksOf("summary ~ Deployment"))

How do I combine these queries?
Thanks a lot!

Kind regards,
Steffen

[Jack Nolddor _Sweet Bananas_ · Accepted solution]

Omg! sorry I didn't read properly the requirement hahaha

You must use parentsOf() instead

project = XXX AND issuetype = "Story (Development)" AND status in (Resolved, Closed) AND resolution in (Done, Fixed) AND issueFunction in parentsOf("summary ~ Deployment") ORDER BY priority ASC, "Epic Link" ASC, summary ASC

Regards

[Steffen Jantke]

Perfect! That's exactly what I was looking for. Thank you, Jack!

[Jack Nolddor _Sweet Bananas_]

Hi

I' didn't understand what kind of issues do you want to retrieve, do you mind to answer the following?

Display issues not having subtask at all?
Yes/No

Display issues having subtask with summary containing Deployment word?
Yes/No

Display issues having subtask with summary containing others word?
Yes/No

I will reply you with the desired JQL

Regards

[Steffen Jantke]

Hi Jack,

This one is the correct request:

Display issues having subtask with summary containing Deployment word

The JQL query for that would be perfect! Thank you very much!

[Jack Nolddor _Sweet Bananas_]

Hi

Could you try the following advanced search?

issueFunction IN subtasksOf("summary ~ Deployment"))

...should do de trick, note that the above JQL is based on Script Runner for Jira with is not shipped with the application OOTB.

Is not possible to retrieve the desired data using native features.

You can also try other third-party apps like JQL Booster Pack to retrieve the desired data

Regards

[Steffen Jantke]

Sounds good and logical, thanks for that. Unfortunately, I cannot find any issues:

No issues were found to match your search
Try modifying your search criteria or creating a new issue.

Maybe the main query has a mistake here? Could you please take a quick look?