Using filter to have a snapshot of the past

[VMinh]

Hi!

Looking for help!  Ideally a solution that doesn't require buying a plug-in.

My filter :

project = MyProject AND issuetype = "Bug" AND status was not in (Done, Rejected) on "2023/05/20"

The result will offer me a column with the current priority, but I would like to display the priority at the provided date in the past.

Ideally if I export it in .csv, I want to see the priority on that date.

Thanks!

[Trudy Claspill · Accepted solution]

Hello @VMinh 

Welcome to the Atlassian community.

The results/output of filters are designed to give you the current information for issues that meet your criteria.

The Status value displayed in filter results will always be the current Status value. If you want to display the Status value from a particular date you would need to save that value into a separate field.

You cannot get what you want with just filter results or the standard CSV export of the issue information because neither displays historic information about the issue.

You need a tool that will parse through the transition history of an issue to determine the status of the issue on the date that you provide. There is no such built-in report in Jira.

Are you unwilling to consider any app at all, or only apps for which you have to pay? I don't know if there are any free apps that would help with this.

You could try to develop your own tool leverage the REST API.

[VMinh]

Hi thanks for you answer!

I'm trying to avoid paying for an app.

The whole idea is to create in excel tables, then graph that will display the amount of Blocker, Major and Minor Priority Bugs through time. 

Note : A bug priority can sometime change at some point in time after reconsiderations, thus my question.

My intention was to exporting many past-time snapshot, export it in excel and manipulate the data.  Would you have any other suggestions that could also achieve this goal?

Thanks!

[Trudy Claspill]

I missed that you want to see the Priority on that date, but otherwise my answer is basically the same. Filter results are going to show you current information, not historic information.

You could use the CHANGED operator against the Priority field to find the issue that have and the issues that have not changed the value of the Priority field since the specified date. 

project = MyProject AND issuetype = "Bug" AND status was not in (Done, Rejected) on "2023/05/20" and and not priority changed after "2023/05/20"

not priority changed after "2023/05/20"

...will constrain the results to only the issues that have also not had a change in the Priority value since the specified date. In that case, the current Priority value is the same as the value on that date.

priority changed after "2023/05/20"

...will constrain the results to only the issues that have also had a change in the Priority value since the specified date. In that case, the current Priority value may or may not match the value on that date. The Priority may have been changed more than once since then, so it may have been changed back to match the value on that date.

Is this something you are going to need to do repeatedly as the months pass?

If this is a one time need I would recommend that you consider looking for an app that would meet your needs, getting that app for a trial period, get the report completed, then uninstall the app.

If you are going to need to keep doing these report then I would recommend you start doing a daily export of the current information of the issue, rather than trying to get the information after the fact. Or build your own tool. Or check the apps that are available to see if you can find a free one that will meet your needs.

[VMinh]

Thank you for your answer!
The info is all in Jira... just sad that these simple requests are not native.

I'll find some manual way to get my info.

Cheers!