-
Suggestion
-
Resolution: Unresolved
-
None
-
None
-
251
-
16
-
NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.
Problem Definition
JQL does not have a means for users to be able to search for which issues have been added or removed from a sprint.
Suggested Solution
Create a new JQL function that can do this natively
Why this is important
It would help identify these issues in searches, but also then could be very useful on board say as a quick filter to see very fast which issues were added after the start of a sprint.
Workaround
This is something that 3rd party plugins have already achieved, such as Scriptrunner in https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html#_addedaftersprintstart
Original description:
It could be useful to be able to search for issues that were added or removed from a sprint during it's progress.
A customer even tried to get help from Script Runner support, but the according to the support, the respective function that could return that result is available only to the Server version of Script Runner.
It would be great to have it built natively.
- is cloned from
-
- Gathering Interest
- mentioned in
-
Page Failed to load
[JSWSERVER-20097] JQL search for issues added and removed from a sprint
This functionality/data actually exists in the Sprint Retrospective Reports. Kinda strange that it's not exposed in JQL
5f36f87b5c76, This is how I got ScriptRunner to pull those tickets that were added to the Sprint after the Sprint started.
In ScriptRunner, enter the following code.
sprint in openSprints()
and sprint not in closedSprints()
and issueFunction in addedAfterSprintStart("Your Scrum Board Name")
and issuetype != "sub task"
and "Product Family / Product Team" in ("Team Name")
ORDER BY Key
This will pull issues that were added after the Sprint started
Then create a regular filter that references the ScriptRunner filter.
sprint in openSprints()
and sprint not in closedSprints()
and filter = ScriptRunner Filter Name
and issuetype != "sub task"
and "Product Family / Product Team" = "Team Name"
ORDER BY Key
You will then be able to use the results in boards, gatgets, etc.
One thing I found confusing when I went to edit my JQL filter is that the portiion that says
"filter = ScriptRunner Filter Name "
Turned into something like this:
"issue in (523983,523989,524223,524738,525277,527969)"
Somehow, this is the list of tickets identified in the ScriptRunner filter. I dont know what those numbers signify though.
I was able to get this info using ScriptRunner, but my company is no longer paying for this add on. This functionality should be native to Jira. You already have it working in the Sprint Report, why cant I get that same functionality to populate widgets on my Dashboard which I use in my Daily Stand Up.
This feature would give us so much extra control over what is happening with our sprints. This feature is extremely wanted in our team!
+1
This issue is adressed 5 years ago!!! When does Atlassian think it's created??
+1
The lack of this feature is truly distressing. As others have observed, there is an existing flag that is available on the "Sprint Report" denoted by an asterisk. A report that you cannot even export to csv. The Burndown Chart report produces a list of initial items in a table and provides event details meaning there are in system flags that can be leveraged. Also cannot export. The Velocity Chart captures the Commitment point in some way. I can only assume like others have that this is less of a performance decision and more of a marketing one, locking this crucial information behind paid tools. Introducing the manual waste of directly copying page details into another format for evaluation, a wasteful operation that is at risk of so much human error. Or introducing the need to somehow manually flag these items which is also additional waste in the form of another burdensome task for teams and a gap that manual data entry introduces.
When I go to the Atlassian page on Jira, the first thing I see is
"The #1 software development tool used by agile teams". The marketing here isn't focused on support teams, nor project management teams - it is targeted at Agility. Regardless of the Agile method or framework teams are using, there is a heavy emphasis on empiricism. Basing your current plans on previous performance is absolutely necessary. Being able to understand trends in your team and highlight them is an absolute must to the basics of this product. Without that, I challenge its alignment with being "the #1 software development tool used by agile teams". Do not send me to third party tools here, when the majority of your userbase would find themselves in a corporate setting where we cannot leverage these tools directly or a private one where these tools may be cost prohibitive. Not for something that should be as foundational as this to your core target market. This is foundational information which can be used to analyze a teams focus, predictability, trends, impacts. Locking their availability to reports which are not easily digestible to a team is not a solution. Give us the data our teams produce through the same JQL engine you expect us to use for so much other information. Please seriously consider this and thank you.
Well over 5 years and 1.5K votes (between cloud and server tickets) and still waiting ...
+1, especially since this scriptrunner function no longer works on cloud
How many requests are needed before you change the status from gathering interest to assigning it to a developer??
We have been waiting for at least a year for the ability to pull this info directly from Jira with a simple JQL statement.
@atlassian, what do we need to do to get this moving forward. As a development manager, it is incredibly helpful to see what items are being injected, or pulled, from an active sprint. Having the ability to identify these items on a dashboard would be very useful for daily planning and overall visibility. This functionality exists for issues removed from sprint in the standard "Sprint Report", why don't you expose it for JQL. I see that this has been a common request/complaint for years now. A simple JQL feature would be adequate.
@atlassian, curious how many +1's and years something has to sit in 'Gathering Interest' before someone thinks it has enough interest to implement? Between this issue an the issue it was cloned from, it looks like it could be valuable to a lot of your users
+1 - incredibly sad that the reporting provided to SMs provides only limited data. It seems odd that Jira "knows" this by giving us the not-so-useful asterisks, so it must be in there somewhere. The burndown also provides changes to sprint scope, so why are we not able to hook on whatever Jira is using to pull that information for an actual sprint report, which is where it would be most useful.
+1
This is an essential feature, and it's absence is so frustrating; there are plenty of reasons why we might move a ticket from one sprint to another, and we should be able to query and analyze these transitions. The sprint history is maintained in Jira - the History tab shows every time the Sprint field changes; it's a serious omission that you cannot access this in JQL.
+1 This would make my reporting so much easier! (Company does not want another add-in)
Hi everyone, just till this ticket is resolved, you can try GO! JQL: Essential JQL Functions
Doc: https://almbase.atlassian.net/wiki/spaces/MDOC/pages/4100555652/Sprint+JQL+functions
Marketplace: https://marketplace.atlassian.com/apps/1225063/go-jql-essential-jql-functions?hosting=datacenter&tab=overview
@atlassian, Any update on where this stands? This seems like a common sense feature
Although it wouldn't address ALL of the requirements here (especially in terms of ADDING) having the ability to do
sprint was in (sprintname) and sprint not in (sprintname)
would be a good start here, especially because
fixversion was in (fixversionname) and fixversion not in (fixversionname) DOES work as expected and has done for some time I believe.
+1
With the added requirement in our company that this should be useable for visualization on a scrumboard (for card colour or swimlane).
I have also just noticed that the Scriptrunner workaround seems to work (as it does not require hardcoding the current sprint).
But it is a little weird to me that Jira shows this only with asterisks in the sprint report and not on the board itself.
Hello everyone,
You can search the issues added to or removed from sprint after sprint starts with the GO! JQL plugin. It is for Jira Server and Jira Data Center. The Jira Cloud version will be released soon. Here is the [documentation|https://almbase.atlassian.net/wiki/spaces/DOC/pages/4028989441/Sprint+JQL+functions].
I hope it helps, bests!
If you have a user that just "Removed" an issue and didn't actually DELETE the issue, you can automate it. If the issue is put in the "removed" status, you can do one of the following:
- Send an email to yourself when an issue in "openSprints" is put in the Removed status (you might even be able to do it if it is deleted but not sure about that) via automation
- Send a slack instead of email
- If #1 occurs, you could also immediately transition the story to either the backlog OR the current sprint and add an "Attempted Removal - " at the beginning of the Summary.
*I have done this successfully on a Kanban board if someone removes an issue after it has been started, regardless of current status. I know the same can be done using sprints.
MY issue is I need to know if someone removes a specific label and be notified when that occurs.
I figured out that you can use fieldChange.fromString and fieldChange.ToString for my issue. It is possible a variation of this can help the OP's issue.
+1
And agree, we shouldn't have to prove a need if it's a common use functionality that should be available anyways!
+1
Info is already presented in the report.
Please provide the same info via JQL to be imported to the Confluence page.
Clearly, everyone wants this.
How much more interest is needed to demonstrate the impact of this relatively straightforward request?
+1
As Agile Coach, this is a key concept to be tracked in order to get usefull metrics for any team/organization. It is impossible to get real metrics based on "all issues" added to a sprint instead of all issues the team "planned/confirmed/committed" to do in the sprint. It is also very hard to get all issues that was "finished/validated" in that sprint (because they can be moved along different sprints in their lifecyle, even when it is not the desired case).
I can't understand how Jira use that data in so many graphs, reports and tables but it is not exposed even in the database for mining them.
Thank you for taking this into consideration and making all organizations more agile, flexible and actionable!
+1 from me as well. Please don't force us to abide to the paradigm of not moving tickets out of Open Sprints - sometimes we are interested in what moved in/out of Open Sprints as well, not just by what went in/out of Started Sprints.
+1 yes please with both JSWSERVER-20097 & JRACLOUD-75868) to add the feature to JQL like mentioned in Ricardo's prior comment
+1 please, this information has been removed from the reports section.
Adding a Vote for this new feature. We cannot have all the add ons. Thanks
Please, add this feature. It could be super useful to keep track of the sprint status and right now we can only make workarounds.
Is there an update here? Per the ticket's history, looks like there's been interest gathering/building for over 2 years now despite the obvious voice from the user base demonstrated just here
Atlassian will never give us this. They are relying to much on the Add ons build by others. And those people will get angry if Atlassian will build these kind of features. So Atlassian is in a tight spot now. They cannot give us features that are already there in third party add-ons, and they will lose more and more of their user base on when not building these features.