How to query on any sprint changes

Question

Hi all

Could someone suggest how I can run a query to see if the sprint or due date fields associated with story/task have changed within a given time frame (e.g. in the last 7 days).

We are running a SAFe scaled agile model and would like to run a query to check if any team has changed their active or non-active forward sprint planning and not proactively discussed it in our scrum of scrums.

I understand it may not be possible to do this in Jira natively but we have access to scriptrunner if that helps? Perhaps we can create a listener, populate a dummy field with a timestamp of last changed or something? Even better if we can see the from/to but appreciate that might not be possible.

We are looking to extract the data into Power BI as we're got the connection working between Jira and Power BI so now we are building up our reporting & dashboards.

I've searched this community already but not found anything that fits our needs already answered

Thanks in advance for your help

Roberto Miasack_13nx52 · Answer

@Laurent Lemberger

To find out if the Sprint or Due Date has changed, you can use a custom field as a notification. Maybe it works on Automation for Jira.
* When the Sprint field is changed;
* Edit a numeric field as Field + 1;
(Do the same for the Due Date field)
* Create a filter where this field is always filled;
* Whenever this field is filled, there was a change in the Sprint or Expiration Date.

I hope this works!

Kind Regards

Roberto Miasack

Laurent Lemberger · Answer

Hi Roberto

I need to know for a story/task if the sprint or due date has been changed in a report that lists when they were changed and if possible what from/to. We have a large number (over 1000 stories/tasks) so can't look manually at the card history.

Any ideas gladly received - thanks!

Laurent

Roberto Miasack_13nx52 · Answer

Hi, Lauren.

It was not clear to me whether you need to know how to change the field by sprint or by story (for example).
If knowing when the field was changed by card helps you, you can manually check the card history. And to have this in a report, you can create a custom field that notifies you when the field changes, a counter for example.

Miasack

Kind Regards