The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to do a date search using current sprint's start and end date

Deleted user
December 10, 2018

I have the following jql filter I use for finding issues created during a given time period.

Is there a way to replace the two createddate statements with the start and end dates of the current sprint? (something like createddate >= currentsprint.startdate)

 

project = HHP AND issuetype = Bug AND createdDate >= "2018/11/02" AND created <= "2018/12/08" AND status not in (Accepted) ORDER BY "Scrum Team", created DESC

1 answer

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

4 votes
Answer accepted
Fazila Ashraf
Community Champion
December 10, 2018

Hi @[deleted]

Not as far as i know.. 

But if you follow some standard timeboxes for your every sprints, you could use it like below to get tickets created in last 2 weeks (assuming my past sprint was last 2 weeks):

project = HHP AND issuetype = Bug AND createdDate  >= startOfWeek(-2) and createdDate  <= startOfWeek()  AND status not in (Accepted) ORDER BY "Scrum Team", created DESC

TAGS
AUG Leaders

Atlassian Community Events