Dynamic JQL for current sprint bugs

[Nawoda Herath]

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.

[Milan Kovacs]

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

[Nawoda Herath]

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

[Milan Kovacs]

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

[Nawoda Herath]

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

[Milan Kovacs]

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]

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

[Anne Lam]

This worked for me. Thank you! 

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

[suzanne_deasley]

I am also interested in understanding if there is a function that can provide the start date of the sprint and the end date of the sprint so the JQL would look something like this

issuetype = Bug AND created >= startOfSprint() AND created <= endOfSprint()

What is important to know is during the period of the current sprint, were any new bugs created.  The answers given address bugs that are assigned to the current sprint.  

Sometimes new bugs are created during a sprint period and are not assigned to the current sprint period.