nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Only show Issues that have Sub-tasks with specific Summary

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

Accepted answers

Jack Nolddor [Sweet Bananas]

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

All comments

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

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

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?

Jack Nolddor [Sweet Bananas]

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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

jql