JIRA JQL: problems resolved in the current sprint

Question

I would like to be able to filter the problems that were resolved in the current sprint. As a rule, this will be used to prevent problems resolved in the previous sprint, but delayed during testing (not renewed), when we discuss that the developers achieved this sprint.

Closed problems should also appear, but they are not a problem, as if they were closed by the last sprint, they still will not turn over to this one.

In mock-jql it will look something like this:

project = "Project name" AND status in (resolved, closed) AND statusChanged() > startOfWeek() 

I also saw startofweek()friends, but not something like that startofsprint().

We have JIRA OnDemand, so we cannot install local Java add-ons.

How to get this information?

Answer 1

One of the ways to create queries on the problems that were resolved in the last sprint is to create a filter for them. Then you can reuse this filter in different JQLs so that everyone works on subsets of this main filter. Warning This method is a little time-consuming - nevertheless, it surpasses other alternatives if you work with several filters.

• Create and Save a Filter for Closed in Recent Sprints Issues

  status changed to (Resolved, Closed) after 2014-09-15
  

• In another reuse of JQL, this filter

  // First JQL reusing filter
  project = "My Project" and status in (Resolved, Closed) and filter = "Closed in latest sprint"
  // another JQL reusing filter
  project = "Other Project" and assignee = currentUser() and filter = "Closed in latest sprint"
  

• whenever you start a new sprint, be sure to update the date in the "Closed by last sprint" filter.

, , . OnDemand , , JQL, , .

Answer 2

, , ,

    project = "Project Name" 
    AND sprint in openSprints("Project Name") 
    AND sprint not in closedSprints("Project Name")

. closedSprints openSprints, JQL JIRA. , closedSprints JIRA. , , , ( ). , , , .

, , .

    sprint IS EMPTY

, , , .

Answer 3

openSprint() -.

, :

sprint in openSprints()

Answer 4

The current, rather unsatisfactory solution is

project = "Project Name" and the status is changed to (Solved, Closed) after [YYYY-MM-DD]

where the date must be manually changed to represent the start of the current sprint.

Answer 5

Sprint in (openSprints ()) AND (resolutiondate> startOfWeek ())