You need to find all issues that were not competed in some past sprint, and that are now part of an active sprint. Identify two functions that you…

The two functions that are needed to use in the JQL query to find all issues that were not completed

in some past sprint, and that are now part of an active sprint are closedSprints() and openSprints().

The closedSprints() function returns all issues that are assigned to a completed sprint. The

openSprints() function returns all issues that are assigned to an incomplete sprint. By combining

these two functions with the NOT operator, we can filter out the issues that belong to both a

completed sprint and an incomplete sprint, and only get the issues that were not completed in some

past sprint, and that are now part of an active sprint. For example, the JQL query could be:

project = XYZ AND issuekey NOT IN (closedSprints() AND openSprints())

This query will return all issues in project XYZ that are not in both a closed sprint and an open sprint,

meaning they are either in a closed sprint only or an open sprint only. Since we are looking for issues

that are now part of an active sprint, we can assume they are in an open sprint

only. Reference: Advanced search reference - JQL functions, Modifying closedSprints() to return

previous two Sprints, JQL - Explanation of what closedSprints() does