nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Uday Kiran Bhaviri_cp1r58

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

Summer Hogan_q8imea

@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/

All comments

Uday Kiran Bhaviri_cp1r58

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

Summer Hogan_q8imea

@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

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

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

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_q8imea

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software-server