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; } } }

JQL to show Epics with missing Tasks

Melissa_oqnbbr

Requirement: Show Epics where there is a missing "Review" Task

Background: We have Epics and within those Epics we have a number of Tasks, Draft, Publish, Review etc. We want to see all those Epics where a "Review" Task is missing. The Task name is in the summary field.

Research: issuefunction in issuesInEpics("filter = 123456") - This give me all of the Tasks that are associated with my Epic filter (123546), If I combine this with summary !~"Review" it will show me everything but those Task with "Review" -- This is where I get stuck could I use the issue in childrenOfEpicsInQuery ?

Any suggestion would be greatly appreciated!

Melissa

Accepted answers

All comments

Sanjog Sigdel

Hello @Melissa

Since issuefunction is working for you, please try the JQL below:

issueType = Epic AND NOT issueFunction in linkedIssuesOf("issueType = Review")

In above query try either NOT issuefunction in or try issuefunction NOT IN. Whichever works for you.

This query will simply retrieve Epics that have no linked Task issues.

Now in addition to the query introduce Project and a time duration as per your need.

Melissa_oqnbbr

@Sanjog Sigdel THANK YOU

This is almost working!!

One of my Task Name is "Review Draft" - I was able to use the below search but I need it to be extact , I've tried ("'summary' ~ '"\"Review Draft|""'") But this is not working.

linkedIssuesOf("'summary' ~ 'Review Draft'")

Help!!!

Sanjog Sigdel

JQL Search recommendations should display your status while you type Review. Simply put multiple statuses like this:

linkedIssuesOf(summary, "Review Draft", Done)

Rachit Singhal_zohcl9

Hi @Melissa ,

You can try some different approach for this requirement. Maybe it helps,

you can apply the query - parent in ("Epic 1", "Epic 2", "Epic 3", "Epic 4"...) AND summary ~ "\"Review\""

where Epic 1, Epic 2, Epic 3, Epic 4 are the keys of your Epic.

Please let me know whether you have received your expected results or not.

Thanks,

Rachit Singhal

Melissa_oqnbbr

@Sanjog Sigdel Thank you!

I forgot to include the following the Summary gets appended with an number - Our Summaries are as follows "Review Draft - 1234"

I would need to look for any summary that contained "Review Draft"

I've used the following but it's still show me results that HAVE "Review Draft" I want to see the Epics that do not have this type of Task

project = "XYZ" AND issuetype = Epic AND status not in (Closed, Resolved, "Completed)", In progress) AND NOT issueFunction in linkedIssuesOf("'summary' ~ '\"Review Draft\"'")

Melissa_oqnbbr

@Rachit Singhal Thanks for the suggestion

But this would mean that I will always need to update the query. Also I want to know if the Epic is missing a Task.

So when you have a Project you create an Epic - "Project Jira JQL", in the Epic then you would create your Tasks, we have a number of tasks that Epics should add. I want to see those Epics where the task is missing. So for example show which Epics are missing the "Review" task

Rachit Singhal_zohcl9

Hi @Melissa ,

In my understanding, the built in functionality might not provide you this kind of JQL.

Maybe some plugin might help you.

Thanks.

Welcome!

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

Quick Links

Unanswered
Groups
Help

Find more posts tagged with

server

jira

jira-software

jira-software-server

jql

epic