How to check If task was in sprint?

Mohammad Uzair

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. 

Abel Lineberger

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