Is there an option to highlight the tasks that were included several times in new sprint?

[Katya]

Hello,

Our sprints last one week. When the new sprint is created I am adding there all tasks that were not done in a previous one. I would like to know how many times the task was added to a new sprint and also to distinguish the task that was moved 1 time, 3 times or 10 times. 

Thanks :)

[Bill Sheboy · Accepted solution]

Hi @Katya -- Welcome to the Atlassian Community!

There is no built-in way to query for that information with Jira Cloud.  You can probably do this with a marketplace addon app for JQL.

As a work-around, what do you think of trying an automation rule to give you a quick report at the start of the sprint?  Your project admin may add such rules as this is a built-in feature of Jira Cloud.  That report could show the issues and number of sprints for each one.

Perhaps something like this:

• trigger: sprint started
• action: lookup issues with JQL for this sprint
  • project = myProject AND sprint IN ( {{sprint.id}} )
• action: send an email with the report...something like

{{sprint.name}} just started.  Here are the issues:

{{#lookupIssues}}
* {{key}} was in {{sprint.size}} sprint(s)
{{/}}

And the email would look like this when you receive it:

Sprint 23 just started. Here are the issues:

* TPJS-399 was in 3 sprint(s)
* TPJS-328 was in 2 sprint(s)
* TPJS-312 was in 1 sprint(s)
* TPJS-311 was in 1 sprint(s)
* TPJS-296 was in 3 sprint(s)

To learn more about automation rules, please look at these examples and sources:

• https://www.atlassian.com/software/jira/guides/expand-jira/automation
• https://www.atlassian.com/software/jira/automation-template-library#/label/all/1453
• https://community.atlassian.com/t5/Automation-articles/Jira-Automation-all-the-resources-you-need-in-one-page/ba-p/1388465

Kind regards,
Bill