How can I create a query which shows static results?

[Alex Febroino]

I am creating a query that shows Jira all tickets opened last monday. Tickets have many status (Pending, Cancelled, Redirected, Completed, etc). I can do this search without problem, however I can't make this query result be static (want to represent same status of those tickets from last week). If someone changes one of those tickets it changes the ticket status in my query results and I don't want it.
How may I get the query results static for the day I made the query?

[Fabian Lim]

Hi @Alex Febroino

Unfortunately you can't. The best option would be to export the results via csv/excel.

Cheers

[Alex Febroino]

Thank you, Lim

[Łukasz Modzelewski _TTPSC_]

We don't know what's the use case. But maybe you can change your query not to be related to the statuses, if that is not the most important thing for you.

If you need to see the changes in particular issues, initially found by JQL but without the change of the number of issues you can do following:

1. run JQL search for issues e.g. created on Monday

2. build JQL for those specific issues only with simple query like "issue in (KEY-1, KEY-2)"

But still, if you need to 'save' the current issue state: .csv export is one of the best ways as it would give you the accurate data from the time when it was exported without the option to modify/affect it.

With Jira Cloud you can use some apps to simplify this process e.g if you want to keep the data in 1 spreadsheet (eg. in separate sheets) - instead of X .csv files:

- Jira Cloud for Excel (official) (free app, by Atlassian) - if you need only to get data

- Excel 365 Connector for Jira (paid app, by our team) - if you need a 2-way communication and want to make issue changes in Excel, with read only mode also

[Alex Febroino]

Looks like we'll adopt html exporting and jira macro inside with html codde inside the jira page or csv exporting then copy paste directly to jira.
This Jira Connects looks an interesting thing, I'll check this out. Thank you, Lukasz.

[Rina Nir]

@Alex Febroino 
I suggest you have a look at this App: Jira Snapshots  --> it sounds like the perfect match for what you need, providing you also have Confluence. It basically brings static Jira query results into Confluence.

It has a couple of more advantages:

• You can check what changed over time- the app provides a DIFF view between a static snapshot that was taken just now, and any static snapshot in the past.
• Moreover- you can retrieve hierarchical/multilevel queries: like, all Epics and their respective stories.

Available for Cloud and Data Center.

Full disclosure: I am the CEO of RadBee, the vendor behind this app.

I hope this helps,

Rina

[Alex Febroino]

Thank you, Rina! I'll check this out.