Query on a specific point in time

[Ziv Farjun]

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? 

[Marcin Gebski]

I think what you can benefit from example query:

project = PROJECTKEY AND status WAS Open DURING (startOfWeek(-10), endOfWeek(-10))

It will however need refinement for params of DURING() macro, if you would like to see it with daily resolution

[Ziv Farjun]

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 

[Bastian Stehmann]

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.

[Tarun Sapra]

Hello @Ziv Farjun

You can set up an JQL filter subscription for sending an email every Sunday for issues since the beginning of the year and order the issues by priority.

https://confluence.atlassian.com/jiracoreserver073/working-with-search-results-861257284.html

Subscribing to your search results

A subscription provides you with a periodic notification for all issues returned by the search. If you want to be notified when a particular issue changes, you should watch the issue instead.

[Ziv Farjun]

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