I want a JQL query or list of parent issues that are truly in progress. This means if it is a story with sub-tasks and the sub-tasks have been started, I want to show just the story. If the issue has no sub-tasks I want it to be shown if in progress.
Basically I want to show a high level report of issues in progress and not get into the details of sub-tasks.
Using the issueFunction JQL function that comes with Script Runner you can do the following:
(issueFunction in parentsOf("issuetype = Task And status not in (open, closed)") AND issuetype = Story) OR (issuetype = Story AND status = "In Progress" AND!(issueFunction in hasSubtasks()))
This was able to get me where I wanted in the end. I didn't specify the exact details, but I actually ended up with: ((issueFunction in parentsOf("issuetype in subTaskIssueTypes() And status not in (open, closed)")) OR (issuetype not in subTaskIssueTypes() and status not in (open, closed) AND!(issueFunction in hasSubtasks()))) and Sprint in openSprints() I used subTaskIssueTypes() to ensure any sub-task type is considered and I also need to make sure I only showed issues in the current sprint.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG