Query Jira Issues in the Past but During the Same Release?

[David Kay]

I work for an organization that builds software.  My specific role is that of a Configuration Management Specialist.  It is our function to take snapshots at points in time (figuratively of course) for the sake of establishing baselines.  I need to be able to capture a set of Jira issues at a point in time A and compare another set of Jira issues at a point in time B.  

The comparison will be those Issues/Bugs/User Stories, etc. that were initially Approved to Work vs those that were Approved by Management to Deploy. 

Just short of affixing a bunch of labels to the individual Issues, is there any way that I can extract this data specific to the Jira issues for each individual time segment in order to see what was eeither added or what was removed from the Sprint? 

Are there Jira fields with relevant values that can be queried to achieve my goal?  I have witnessed that Comment-type fields cannot be queried by JQL, right?

Incidentally, this activity occurs after the Sprint has been migrated to Production and the times of interest will be in the Past.  Thanks in advance.

[Rina Nir · Accepted solution]

@David Kay 

I think you should check out the app Jira Snapshots for Confluence . (Disclosure: I am the CEO of radBee, the vendor behind the app).

With this App, you can generate baselines of Jira issues at the (present) point in time. So, if you took one baseline when the issues are approved to work, and then when the release is ready - Jira Snapshots has a DIFF view to compare the two. 

As you mentioned in the last sentence that this is done relative to the past, you probably have two options:
1. Change the flow, and take the Snapshots (baseline) at the relevant points in the Sprint. As taking a baseline is a one-click operation, it might work.
2. If you do not change the flow, I see this involving affixing and manipulating labels. But that seems to be much more manual.

I do not have the full details of your use case, but if you think Jira Snapshots could be a direction for you, then we can discuss the details of how to make it work for you exactly.

Let me know,

Rina

[David Kay]

Rina I do appreciate the feedback and for providing a viable approach.  Consequently, I (we) are not in a position to integrate any plug ins into the Atlassian tools we opeate.  Is there a 'vanilla' out of tthe box solution already in existence?

[Rina Nir]

Hi @David Kay , not that I am aware of