List for incomplete stories under complete epics

[hisham Osman]

Hello everyone ,

I need your help to provide a query that list all stories with status incomplete and under epics that are complete.

[Alex]

Hi, @hisham Osman; welcome to the community!

I am afraid you cannot get this result from Jira "out-of-the-box" in a scalable way. But if you have the issue key for each epic, your JQL would be something like:

project = "YOUR_PROJECT" and type = story AND (statusCategory in ("In Progress", "To Do") or resolution is empty) and "Epic Link"= KEY

However, if your site has ScriptRunner, you can create the following ScriptRunner Enhanced Search:

project = "YOUR_PROJECT" and type = story AND (statusCategory in ("In Progress", "To Do") or resolution is empty) and issueFunction in issuesInEpics("statusCategory='done'")

 Cheers,

Alex

[Taranjeet Singh]

@Alex Don't you think we should also include stories with statusCategory as "To Do" as well in the above JQL queries? 

Please correct me if I am wrong here.

[Colton.Kosicek]

the smartest way would probably be

"resolution is empty"

[Taranjeet Singh]

Yes, I agree with @Colton.Kosicek on that since Resolution field is the right way to determine if an issue is resolved/closed or still incomplete.

[Alex]

Hey @Taranjeet Singh  and @Colton.Kosicek 
Thanks for pitching in with your suggestions, I loved the engagement 😃!!

Yeah, we definitely make the JQL better by adding the statusCategory as "To Do" to both suggestions, actually I have already done that.
But even though, I am positive that resolution is the way go to, we need to make sure that the resolution is filled when the ticket reaches a done status. Therefore, I will consider it as an option for sure.

Cheers,

Alex

[Mayur Jadhav]

Hi @hisham Osman 

Welcome to the community,

you can achieve the required functionality by using a third party plugin, famous one's are 

• JQL Search Extensions for Jira & reports
• Script Runner 

below is the example of JQL Search Extensions for Jira & reports

find all epics with status=done where child's status is not equal to done

issue in epicOf("status!=done") and status=done

Regards,

Mayur

[Daniel Turczanski - JQL Search Extensions]

Hi @hisham Osman ,

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

After you install the app, you can simply search:

issue in childrenOfEpicsInQuery("resolution is not empty") AND resolution is empty

Check out the documentation for more examples.

I hope this helps!
Daniel