I would like to make a query that shows all stories/tasks that fall under epics assigned to specific users. I am trying to develop a board using a filter to display the status of all epics assigned to me only. Various other users may be assigned to stories/tasks under these epics, but I would still like to be able to see them on my board so that I can track their statue.
Thanks Tayyab. This would only pull stories and tasks assigned to the current user. Instead, what I want to do is see all stories/tasks that fall under epics where the epic is assigned to me. That way I could build a kanban board using the query that would allow me to see how all stories/tasks are progressing, regardless of how many different epics I am tracking.
Hi Tayyab -
This is very helpful.
I can't seem to figure out to only show epics that are in progress within the post function. I am getting all my epics with the issue types I want however I have a lot of closed projects that I would want to exclude. Do you know how to add that to your script?
issueFunction in issuesInEpics('assignee = abcd') and issuetype in (story, task)
Are you using Cloud or Server?
If you are in Cloud you can try the following:
project = JRA and parentEpic = JRA-123
This will "return all the issues in the specified epic(s) AND their sub-tasks." Take a look at Dave Meyer's response in JQL to show all issues AND subtasks in the Epic.
In Server you may want to look at ScriptRunner.
I am looking for a JQL query where it searches for all Tasks/Sub-tasks where in the Epic I am the 'Team Owner' (which is a custom field).
I have tried to tweak the above but the closest I have gotten is
issueFunction in issuesInEpics ('Team Owner = (firstname.lastname)')
It is showing as correct but then it is saying : Field 'issueFunction' does not exist or you do not have permission to view it.
Any help would be really appreciated!
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