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

[Meera_Sudhir]

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

[Antoine_Berry]

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.

[Meera_Sudhir]

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]

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

[Meera_Sudhir]

Hello @Antoine_Berry 

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

[Antoine_Berry]

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