Are you in the loop? Keep up with the latest by making sure you're subscribed to Community Announcements. Just click Watch and select Articles.

Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


How can I create a query which shows static results?

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 17, 2022 • edited

Hi @Alex Febroino

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


Like Alex Febroino likes this
Łukasz Modzelewski _TTPSC_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Apr 18, 2022

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

Like Alex Febroino likes this

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 20, 2022

@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,


Like # people like this

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


Log in or Sign up to comment