JQL not retrieving subtask of current sprint.

Shreya M January 2, 2023

JQL used : project = AM AND issuetype = Subtask AND Sprint = 83

I'm using this query but the result is empty even though there are many sub task for the current sprint . Can anyone please help here.

Project type : Team managed project

3 answers

1 vote
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 3, 2023

Hello @Shreya M 

Another alternative is this:

 issuetype in subTaskIssueTypes()

That will retrieve all types of Subtask issue types. That way if you have multiple types of Subtask issues you don't have to remember their names.

Shreya M January 3, 2023

This is retrieving all the subtasks but I want only the sprint subtasks.

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 3, 2023

I apologize for not being more specific. I meant that you should substitute that into your filter where you have "issuetype=Subtask". This is what I meant for you to try:

 

project = AM AND issuetype in subTaskIssueTypes() AND Sprint = 83

If that does not yield any results, then please try this:

project = AM AND Sprint = 83

...to confirm that you have any issues assigned to the sprint. If the above does not yield results, then there are neither issues not subtasks assigned to your sprint.

If the above does yield results, that confirms that you have issues assigned to your sprint. The next step is to examine those issues to see if any of them have Subtasks. 

Subtasks inherit their sprint value from their parent issues. Subtasks cannot be assigned to a sprint independently from their parent issues. If the issues in the sprint have no Subtasks, then there are no Subtasks assigned to the sprint.

If you have issues assigned to the sprint, and you believe the one or more of those issues has Subtasks, please show us the details of one of those issues including the section that shows the type of the parent issue and the section titled either "Subtasks" (for an issue in a Company Managed project) or "Child issues" (for an issue in a Team Managed project).

Shreya M January 4, 2023

got it .Thank you !

Dillon Harless
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!
December 22, 2023

Wildly simple and helpful and this should be at the top of anything related to pulling in subtasks

Lukas Angst April 4, 2024

I would like to use the jql line "Sprint in openSprints()" instead of "Sprint = 83". This way, i dont need to change the query after the sprint is finished. But i dont get the desired subtask.
Do i need to change it?

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 4, 2024

@Lukas Angst 

sprint in openSprints()

This will return the issues that are in Open (started, and not yet Closed) sprints, and will include all their subtasks.

Please start a new Question and provide all the information about your scenario including detailed examples of the subtasks you think should be included in the results but are not.

0 votes
Iryna Komarnitska_SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
January 4, 2023

Hi @Shreya M ,

If you experience difficulties creating JQL queries, try the application my team has developed.

✅With Text to JQL gadget you can:

  • Transform user natural-language text into a JQL query
  • Create JQL queries by voice
  • Gadget is customizable and accepts requests of different complexity
  • Receiving results of query in 1-click

If it's easier, then you just enter a request in ordinary language, and the gadget converts your request to JQL.


The app is free. Enjoy!

0 votes
Karim ABO HASHISH
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 2, 2023

Hi Shreya

would you please try the below JQL

project = AM AND issuetype = Sub-task AND Sprint = 83

Shreya M January 3, 2023

@Karim ABO HASHISH Tried this but it's displaying as "No issues found for this match"

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events