Filter for issues where "Planned Version" has changed

[Martin Härri]

We are using the field "Planned Version" to document when it is planned to put an completed issue into production and the field "Fix Version" to track when this has actually been done.

We would now like to build a filter which shows the issues where the planned version has changed within a specific time frame.

I see that I can filter for changes in "Fix Version", how can I do this for "Planned Version"? Thanks!

[Alex Koxaras -Relational- · Accepted solution]

Hi @Martin Härri  

Unfortunately you can't have this small piece of information with the out of the box functionalities. Advanced JQL operators like "WAS", "WAS IN", "CHANGED" etc work only with a handful of system fields (Assignee, Fix Version, Priority, Reporter, Resolution, and Status).

You could either search the marketplace for an app which may have even more advanced JQL capabilities, or try a workaround which could involved automation copying the planned version to another field, as well as the date that happened.

[Martin Härri]

Thank you, Alex. I'm afraid we do have an an add-in with advanced JQL capabilities, but it does not contain a feature for that. I have to find a manual way.

[Alex Koxaras -Relational-]

@Martin Härri which app you have?

[Martin Härri]

We used ScriptRunner for Jira | Atlassian Marketplace before, but now we switched to Power Scripts - Jira Workflow Automation | Atlassian Marketplace

[Alex Koxaras -Relational-]

I'm not familiar with Power Scripts, but maybe you should take a look at this video https://www.youtube.com/watch?v=sjNRM6X6PTs&t=3s

It might help you create something.

[Martin Härri]

Thank you, Alex. Power Scripts seems to be quite powerful when it comes to issue hierarchies, but does not contain a function to search for changes in fields