Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,293,533
Community Members
 
Community Events
165
Community Groups

JQL filter that will find all Epics in Implementing and all issues in the Epic are in Done status

Here is what I have started I justr cannot get the 2 querirs to work together.

project in ("project") AND issuetype = 10000 AND statusCategory = "In Progress" AND issueFunction in issuesInEpics("status= Done")

1 answer

1 accepted

1 vote
Answer accepted
Filipi Lima Atlassian Team Apr 29, 2022

HI, Thomas! Try using the OR statement to differentiate the two groups:

A:
project in ("project") AND issuetype = 10000 AND statusCategory = "In Progress"
B:
issueFunction in issuesInEpics("status= Done")

So:
project in ("project") AND issuetype = 10000 AND statusCategory = "In Progress" OR issueFunction in issuesInEpics("status= Done")

Se if that's what you're looking for!

Thank you Filipi , I tested it out and it does work ,  I need to find all issues (stories) in Done status this pulls anything under an Epic with a Done status.

If you'd like to further limit the responses from the second part so you only get Stories that are also in Done status, you can do the following:

project in ("project") AND issuetype = 10000 AND statusCategory = "In Progress" OR issueFunction in issuesInEpics("status= Done") and status = Done

That way you'll only get issues that belong to "Done" Epics which are also "Done" themselves.

Also, if you need to limit the second part to a given project as well you may go with:

  • Added line breaks for clarity

project in ("project") AND
(
(issuetype = 10000 AND statusCategory = "In Progress")
OR
(issueFunction in issuesInEpics("status= Done") and status = Done)
)

Like Thomas Cucolo likes this

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you