JQL query that only returns tickets not carried over from previous sprint.

[Chris808]

I just want to know what new items have been taken from the backlog in each sprint and exclude anything carried over from the previous sprint. Have tried reports....there must be a JQL query!

[Mark Segall]

Hi @Chris808 and welcome to the community!

Try this:

project = myProject
 AND sprint IN openSprints()
 AND sprint NOT IN closedSprints()

[Chris808]

Hi Mark,

Thank you! My ultimate goal is to figure out what issues were new in a jira and what were carried over. Even in the closed sprints.

So I have tried, jira in sprint #2 and not in #3 and #4. But there must be a more simple way of identifying the jiras that hadn't been worked on before the sprint in question. 

Cheers

[Mark Segall]

Unfortunately, there is no easy way to query historically.  For this endeavor, it may be best to simply drive the report out of Excel.  I would just execute a filter of all issues for a given time period, include the sprint column, and download to Excel and manipulate as needed.  Probably easiest for a first time effort, then you could have a report that you review at the start of each sprint based upon the query I provided going forward.