JQL to list all Tasks with Subtask where Task.Sprint(x) is set but no Sprint set for Subtask

toohoo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 23, 2024

Hello,

I am searching a way (may be JQL-function) to list all Subtasks assigned to me for defined Sprint in Parent (Task) but Sprint not set in Subtask.

Thanks in advance

2 answers

1 vote
Sebastian B
Contributor
October 23, 2024

Hi @toohoo

not sure what you mean - the Sprint is automatically inherited from Parent to Sub-task.

toohoo
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 23, 2024

No, it is not in our installation.

What happens?

  1. Boss creates Task and sets Sprint.
  2. Boss creates Subtask and assignes me but Sprint is not set in Subtask (not inherited).
  3. I want to search for all my Tasks + Subtasks in this Sprint.
  4. I can't find my Subtasks because the Sprint is not set in Subtask.

 

If I had a function like SprintOfParent() I would be able to search for it.

0 votes
Prosper Agwegiokhe October 24, 2024

Hi @toohoo,

Welcome to the Atlassian Community!

I’m Prosper, a support engineer at Appfire, and I’m here to help.

If you are open a plugging suggestion, you can try out our App JQL Search Extension for Jira.

You can use the query:

issue in ChildrenOfIssuesInQuery("{jql function}")


To get the children of a parent task.

If you have the key of the parent, in your case the task key, you could do something like this:

issue in ChildrenOfIssuesInQuery("{parentKey}")


or you can also pass in the sprint and filter as needed:

issue in ChildrenOfIssuesInQuery("sprint = 1")


You can see more information about this query here, and please contact our support if you have any other questions about this query.

We’ll be happy to help you!

Best regards,
Prosper.

Suggest an answer

Log in or Sign up to answer