jirajqljira-agile

querying tickets with * mark JIRA JQL

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

Solution

  • 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.