Hello everyone ,
I need your help to provide a query that list all stories with status incomplete and under epics that are complete.
Hi @hisham Osman
Welcome to the community,
you can achieve the required functionality by using a third party plugin, famous one's are
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
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 <span>in</span> <span>issuesInEpics</span><span>(</span><span>"statusCategory='done'"</span><span>)</span>
Cheers,
Alex
@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.
the smartest way would probably be
"resolution is empty"
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.
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
It looks like you're new here. Sign in or register to get started.
