Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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