Filter on changes

[Nils Ejlertsson]

I have a test team that writes Fault Reports (FR) on other teams. I have a filter for all the FR my team are ether reporter or assignee for, but I want to filter out all FR that has not been changed in any way i.e. only FR with new comments, new status or new resolution.

I suppose I need to set a timeframe for the changes and within 1 day would be preferred.

Hope someone have some magic to share :)

[Trudy Claspill]

Hello @Nils Ejlertsson 

Welcome to the Atlassian community!

The ideal way to do this would be to be able to compare the Created Date of the issues to the Updated and Resolved Dates of the issues, but natively Jira does not allow you to do that within a filter.

A third party app that extends JQL functionality might enable you to do that.

Do you have or are you open to acquiring such a third party app?

[Nils Ejlertsson]

Not that I am aware of. A shame filtering on changes is not part of basic functionality as it would be useful for so many different use cases.

Do you have a plugin that you can recommend to do this data handling?

[Trudy Claspill]

The Adaptavist Enhanced Search (a.k.a. ScriptRunner)  app has a dateCompare function that supports this:

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

Other JQL extenders may also have a similar function