JQL to show Epics with missing Tasks

[Melissa]

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 

[Rachit Singhal]

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]

@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]

Hi @Melissa ,

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

Maybe some plugin might help you.

Thanks.

[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]

@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) 

[Melissa]

@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\"'")