Filter to list issues whom story points have changed

[Sebastian Ghelerman]

Purpose

I am trying to create a search filter using the JQL language that allows me to track whether story points field in issues from given project have changed.

Problem

While trying to do this I found that field "story points" does not allow "CHANGED" operator. Is there another way to fulfill the purpose of the filter?

[Archi Apronti]

@Sebastian Ghelerman Here's how I achieved this using two automation rules.

Rule 1 - Track story point changes for issues in a specified project and add a 'specific comment'

Rule 2 - Fetch all the issues with the stated comment and compile into a report to be delivered via email etc

I hope this helps.

[Bill Sheboy]

Hi @Sebastian Ghelerman  -- Welcome to the Atlassian Community!

What problem are you trying to solve by seeing changes to the story points?  And, is this a one-time issue or a long-term one that needs monitoring?

I am asking because, as you noted, CHANGED only supports a limited number of fields, so it can be difficult to answer this question with out-of-the-box JIRA Cloud.  And JQL is not a SQL,  so it cannot do most simple functions that an actual database query language can perform. 

If this is a one-time need for a few JIRA issues, I would open each item up and look at the change log to see if the field changed.  If instead there is a good reason to monitor this long-term, you could build your own solution using automation rules and custom fields:

• Create a rule to:
  • Detect the story point field has changed
  • Notify of the change (email, comment, custom field, etc.)
  • Save the new value for later comparison
• Create another rule to report on changes:
  • Trigger the rule on a schedule
  • Use JQL to look for the change indicator you saved
  • Roll up the results into a report
  • Send the report
  • Reset the change indicator flags 

To learn more about automation rule, please see:

https://support.atlassian.com/jira-software-cloud/docs/automate-your-jira-cloud-processes-and-workflows/

Best regards,

Bill

[Sachin]

Hello @Sebastian Ghelerman , you can check for Issues missing Story points - "Story Points" is EMPTY , but you can't check for what's changed to the field. See How do I query Story Point updates in JIRA? , please vote and watch this feature request here - JRACLOUD-67469