Hey everyone,
I’m trying to figure out how to search for Jira issues that were marked as ‘In Progress’ within an hour of being created. Does anyone know a good way to do this?
I’ve been playing around with JQL, but I’m not sure how to combine the creation date and status change time effectively. It would be super helpful if someone could point me in the right direction or share a sample query.
Thanks in advance for any tips or tricks you can offer!
As someone who’s been wrestling with Jira queries for years, I can tell you that finding issues moved to ‘In Progress’ shortly after creation is a bit tricky with standard JQL. However, I’ve found a workaround that might help.
Start with a basic JQL query like this:
status = ‘In Progress’ AND created >= startOfDay(-7d)
This will give you all issues moved to ‘In Progress’ in the last week. From there, you can export the results to a spreadsheet and use Excel or Google Sheets to calculate the time difference between creation and the first ‘In Progress’ status.
For a more automated solution, I’d recommend looking into ScriptRunner. It’s a powerful add-on that lets you write custom JQL functions. With it, you could potentially create a function to check the status change history and filter based on the time difference.
Remember, Jira’s built-in JQL has limitations when it comes to complex time-based queries, so sometimes you need to get creative or leverage additional tools to get the exact data you’re after.
hey mate, i ran into this before. jql’s kinda limited but u can try: status = ‘In Progress’ AND created >= -7d then export to excel to sort by created & status change. not perfect but works ok. cheers!
I’ve dealt with similar queries before, and while JQL doesn’t directly support this, there’s a workaround. Start with:
status = ‘In Progress’ AND created >= startOfDay(-7d)
This fetches ‘In Progress’ issues from the last week. Export to Excel or Google Sheets, then use formulas to calculate the time between creation and status change. For each issue, subtract the ‘Created’ date from the ‘Status Changed’ date.
For a more automated approach, consider Jira add-ons like ScriptRunner or Automation for Jira. These allow custom JQL functions and automated workflows that can track status changes relative to creation time.
Remember, Jira’s native JQL has limitations with time-based queries, so sometimes external tools or manual data processing are necessary for complex analyses.