JQL for Experts: Show Epics without Sub-task to closed Test Tickets

[Steffen Jantke]

Hi everyone!

I have the following use case:

If there is a closed Test ticket in an Epic ticket, there must be a Sub-task on the Epic ticket, that contains "Deployment:" as the summary field and has a link to the Development ticket from the corresponding/linked Test ticket.

If there is no sub-task, show it to me!

Puzzle 1: project = XXX AND issuetype = Epic
Puzzle 2: status IN (Resolved, Closed) AND resolution IN (Done, Fixed)
Puzzle 3: issueFunction not in parentsOf("summary ~ Deployment")

I'm going crazy here. I've rephrased the filter description about ten times and I just can't get a bridge.

I hope you guys can help me.
Thanks in advance.

Kind regards,
Steffen

[Steffen Jantke · Accepted solution]

Sorry that I have to give myself the accepted answer. ;-)

I just got it put together:

project = XXX AND issuetype = Epic AND status NOT IN (Resolved, Closed) AND issueFunction IN linkedIssuesOf("issuetype = Test AND status IN (Resolved, Closed)", "has Epic") AND issueFunction NOT IN parentsOf("summary ~ Deployment")

I hope I can help others with these snippets.

The following pages have helped:

• Script JQL Functions
• Use advanced search with Jira Query Language (JQL)