How to check If task was in sprint?

Mohammad Uzair March 19, 2019

I need the issues which are marked as Done between a certain date range but not a part of the sprint that was running at that time. So how can I can achieve this using JQL?

 

Thanks in advance. 

1 answer

0 votes
Abel Lineberger March 19, 2019

so the JQL query would include:

  • project = x
  • statuscategory = done
  • updatedDate >=  the starting date of the range 
  • updatedDate <= the closing date of the range +1 
    (see the example below - the range is actually Mar 09 to Mar 15, if the closing date is input as 2019/03/15 I find that the query does not return issues marked as done after noon on the 15th)
  • Sprint is Empty

So the query ends up looking like:

project = <project name> AND statuscategory = Done AND updatedDate >= "2019/3/09" AND updatedDate <= "2019/3/16" and Sprint is EMPTY

Suggest an answer

Log in or Sign up to answer