I cannot find these, but I imagine they are used in the velocity report.
Are there JQL functions for 'sprintCommitted()' and sprintDelivered()?
team in (112) and sprint in (555) //columns are committed vs delivered
Hi @Gil Carroll
I am assuming you mean the number of issues (or sum of story points) which were committed when the sprint started, and the number/sum which were completed when the sprint finished.
If so, the short answer is "no; there is no JQL to directly return this information". JIRA appears to use the issue history to roll up the values based upon the sprint time-frame and what happened to the issue over time, such as scope changes and story point value changes.
There are probably marketplace add-ons which would support these concepts. Alternatively, you could export the items and parse the Sprint field to determine what was added/finished and when. You would still not have visibility to any changes to scope or story points with this work-around.
I don't know if this is what you are looking for but for each sprint you can use this query:
sprint=29244 AND issueFunction in aggregateExpression("Total time", "originalEstimate.sum()")
in order to know the total time estimated. (in my case Total time:26 weeks, 1 day)
With this query instead you can retrieve the remaining work for the same sprint
sprint=29244 AND issueFunction in aggregateExpression("Total remaining time", "remainingEstimate.sum()")
(in my case Total remaining time:2 weeks, 2 days, 3 hours)
Hope this can help, please mind to update the query with your sprint ID
One important distinction I believe you are not comprehending is that JQL returns a list of issues. Nothing else. You cannot have JQL return a numeric value or count. What you can easily do is use the velocity chart to see committed vs delivered story points: