Query on a specific point in time

Question

I want to create a query on a specific point in time.

For example, I want to see all open jira tickets for component X, with  break down according to priority.

I want to do this for every Sunday since the beginning of the year 1/1/18, so I see trend of the number of issues for component X per priority

Any ideas how can this be done?

Bastian Stehmann · Answer

You can not really query a snapshot of Jira.

What you can do, is to use the "WAS"-Operator as mentioned be @Marcin Gebski. This works for some fields, but not for all. If you want to query a specific time instead a date-range, you can use ON instead of DURING.

Please have a look at the advanced searching docu:

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-operators-reference-764478341.html

There is a more detailed description.

Ziv Farjun · Answer

Thanks @Marcin Gebski , the use of week number is excellent.But what I would also like to know if there is a way to query Jira "Snapshot" on a specific point in time

Ziv Farjun · Answer

Thanks @Tarun Sapra for your answer.

It will help me understand how many tickets were open in each week and solve the need to send an email each week. But what I would also like to know if there is a way to query Jira "Snapshot" on a specific point in time