Dynamic JQL for current sprint bugs

Nawoda Herath February 20, 2020

Hi All,

I want to create a JQL which will help me to filter bugs which are created within the current sprint. I do not want to hardcode start date and end date as I'm supposed to use this in the dashboard.

1 answer

0 votes
Milan Kovacs February 21, 2020

sprint in openSprints() AND issuetype = Bug ORDER BY created DESC

Nawoda Herath February 21, 2020

Thanks but this will not help. I wanted to filter bugs created within the sprint. This is a ordering only

Milan Kovacs February 21, 2020

sprint in openSprints() AND issuetype = Bug ORDER BY created DESC

Nawoda Herath February 21, 2020

It is same as the previous @Milan Kovacs , Isn't it?

Milan Kovacs February 21, 2020

sprint in openSprints() filters bugs to the CURRENT SPRINT, so it's not an ordering only. 

Using this with the 'ORDER BY created DESC' on your JIRA dashboard gives you a dynamically updating filter, Sprint after Sprint.

Hope this helps.

Nawoda Herath February 21, 2020

Unfortunately no. This gives bugs which  created during past sprints as well but display order shows current sprint bugs first

Anne Lam
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!
November 23, 2022

This worked for me. Thank you! 

Sounds like OP needs to close out his older sprints..!

Suggest an answer

Log in or Sign up to answer