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 ?