0

i need to extract churning tickets using JQL. Normally churning tickets have a * mark after the ticket number. Is there any way to identify that?

Example for Churning ticket ABC -128 *

enter image description here

johnson
  • 379
  • 2
  • 17

2 Answers2

1

Can you define "churning" and normally Jira doesn't have a * next to issues. Perhaps there is some app that does this?

You can sort issues by their last modified date if that helps

mdoar
  • 6,758
  • 1
  • 21
  • 20
  • Churning is adding new tickets that are previously not included in Planning for the sprint. please check the question again. I have added a screenshot – johnson Jul 18 '22 at 18:33
1

The star after the issue means that this issues were added after the sprint started.

You can check this documentation:

Issues added after the sprint starts are indicated with an asterisk.

Not sure if the issue has an attribute like "Sprint date" which identifies the date that the issue added to sprint. For the next ones, you can create a custom field and fill that field with the current date on the issue sprint event. Thus, you can filter it on JQL.

Other than that, there is no way to understand the issue is added to the sprint before/after it starts.

stuck
  • 1,477
  • 2
  • 14
  • 30
  • https://community.atlassian.com/t5/Jira-questions/JQL-to-determine-what-issues-have-been-added-after-sprint-start/qaq-p/778281 has a few directions to investigate, depending on whether this is Cloud or on-prem – mdoar Jul 19 '22 at 20:16
  • It also looks like you might be able to get the issueKeysAddedDuringSprint with the undocumented REST resource https://jira.example.com/rest/greenhopper/1.0/rapid/charts/sprintreport?rapidViewId=2555&sprintId=61892 – mdoar Jul 19 '22 at 20:17