Find issues that started within the hour they were created

[J.M.]

Would like some help coming up with the JQL that would tell me:

for all issues in a project, return me all issues that started within 1 hour of each of their respective createdDates

[Joe Pitt]

What criteria do you propose for 'starting'? 

[J.M.]

Status changing from draft to In progress

[Joe Pitt]

I'd start by looking here: https://community.atlassian.com/t5/Jira-questions/How-to-write-a-JQL-to-find-issues-status-changed-on-Last-week/qaq-p/231919 

[J.M.]

Was unable to nav to that link. getting invaild parms message

[Joe Pitt]

For some reason it adds stuff after the last 9 in 231919. Delete whatever comes after and refresh

[J.M.]

Thanks! This narrows it down a bit but does not get what I'm looking for. I'd like a list of issues (over the life of the project) that were started within an hour of their respective created date.

The link details looking at things that start within a dynamic time period only

[Joe Pitt]

You'll have to play with the JQL. I normally use custom fields to capture milestone dates so they can easily be seen my management. No one has asked for detail down to the hour.  I would think that would be a service desk metric. 

[J.M.]

Thanks for the help! I'm trying to show my kanban team the impact or at least visualize the these kind of issue and how that effects flow