Filter to list issues whom story points have changed

Question

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 · Answer

@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 · Answer

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_q0v8o8 · Answer

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