Query to list tickets/issues exclusively added to particular sprint

[suyash bhogawar]

I have seen several issues getting added from sprint 1 to sprint 2 and then sprint 3. however i am looking for issues which were/are exclusively added to a paricular sprint. 

For eg:
Issue 100 is added during sprint 1 and then was moved to sprint2. 

issue 101 was added to sprint 2 only. 

So i want a query which will give me issue 101 as it was added explicitly during sprint 2. it was not moved to sprint 2 from earlier ones. 

[Petter Gonçalves]

Hello @suyash bhogawar

Welcome to the Atlassian Community!

Indeed, we don't have a JQL query to filter to a specific Sprint excluding the other nested Sprints added before. We see the value of having this option, so I created the following feature request as a JQL improvement to achieve your goal:

JQL to find issues that have exactly only one Sprint 

Feel free to vote and watch the suggestion to increase its priority and also receive notifications about any updates.

As a possible workaround, you can use the closedSprints() function to consider only the current Sprint in the search. This approach will work if the Sprint you are looking for is still open.

Let me apply it using the example you gave above:

If the Sprint 2 is still open in your board, you can use the following filter to return the issues that were not dragged from a previous Sprint, but added directly to the Sprint 2:

sprint = "Sprint 2" and sprint not in closedSprints()

Let us know if you have any questions.