Need help with JQL to query all stories and parents of sub-tasks assigneed to me

[Rick Dorgan]

I'd like a query that lists all of the stories I own in the active sprint, along with all of the stories that have me listed as a sub-task owner in the active sprint. Is this doable?

I can get a list of all the stories and sub-tasks which doesn't quite hit the mark. It results in some redundancy, since in some cases, I am both the story assignee, AND the sub-tasks assignee. This is why I'm hoping to just show a list of stories.

[Uday Kiran Bhaviri · Accepted solution]

sprint in opensprints() AND assignee = currentuser() OR (issueFunction in parentsOf("sprint in opensprints() and  assignee = currentUser()"))

You can use the above JQL query if you have scriptrunner app installed in your instance. 

For more details on issue function usage you can go through the below link

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sub-tasks#id-.Subtasksv6.36.0-parents 

[Rick Dorgan]

I'll need to confirm with my admin on Monday, but not sure I do given some unexpected results when I use your query. Is this only possible with the scriptrunner app?

The query might be close...if I could just hide the sub-tasks from the results, I think it would be what I'm looking for.

[Rick Dorgan]

Need to investigate more, but it might be working after all. I included a Priority filter, which was excluding sub-tasks with missing priorities. Need to go through and do some cleanup to be certain, but I think that was my problem. Thank you!

[Rick Dorgan]

Confirmed. It worked, just needed to clean up some data fields on my side. Thank you!

[Summer Hogan · Accepted solution]

@Rick Dorgan - you might want to RSVP to this Live Learning event. It might help you with JQL. 

https://ace.atlassian.com/events/details/atlassian-live-learning-presents-get-started-with-jira-software-february-2024-cohort/ 

[Rick Dorgan]

Thank you! Just RSVP. Could definitely use some guidance.

[Summer Hogan]

Sure, no problem and happy to help! Since I helped you out, can you please Accept my answer?