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.
Hey David,
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()))
Enjoy
You need to replace "Task" with "Sub-task" in the parentsof subquery, beside that the answer is correct
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.