It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How does sprintStartDateOf() and sprintEndDateOf() functions work?

Hello,

I need to find the number of bugs resolved in the past few sprints and tried the following query

resolved >= sprintStartDateOf("Sprint Name", "Board Name") and resolved <= sprintEndDateOf("Sprint Name", "Board Name")

But this query does not return any data.

Can someone help in understanding the correct usage of these functions in JQL?

Thanks in advance!

Best Regards,

Meera

 

1 answer

0 votes
Antoine_Berry Community Leader Jan 07, 2020

Hi @Meera_Sudhir ,

if you replace the sprint dates by the actual dates in the JQL, does it work ? Maybe the resolution has not correctly been set between these two dates.

Hi @Antoine_Berry ,

Thanks for the quick response.

I tried the following query to make sure that there are tickets resolved for that period ans are actually included in the sprint:

project = "Project Name" and resolved >= "2019/11/11" and resolved <= "2019/11/22" and sprint = "Sprint 1"

I got 60 rows.

Then I tried the following queries:

  1. resolved >= sprintStartDateOf("2019/11/11", "Board Name")
  2. resolved >= sprintStartDateOf("Sprint 1", "Board Name")

Both the queries returned 0 rows.

I am not sure what I am missing here. 

Antoine_Berry Community Leader Jan 08, 2020

Are you positive the exact name of the sprint is "Sprint 1" (never sure enough...) ? Does this : resolved >= sprintStartDateOf("Sprint 1") work ?

Hello @Antoine_Berry 

I did cross check the sprint name and it seems to be ok :)

Antoine_Berry Community Leader Jan 23, 2020

So this request "resolved >= sprintStartDateOf("Sprint 1")" returns results ?

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you