JQL - closed during 24h after creation time

[P Hubalová]

Hi, 

does anyone know how to search for JIRA tickets which were closed within 24h after creation time? 

Thank you. 

[Brant Schroeder]

@P Hubalová Welcome to the Atlassian community

This would require a calculation to occur which is not possible using delivered JQL.  You could run a JQL query and export to excel and create the calculation that provides this information.  You could also create an automation that runs when the issue closes that performs the calculation and places the calculated information in a custom field that you can report off of.  If you use Jira Service Management you can have an SLA that provides this information.  I believe you could also use one of the many apps from the app store that provide enhanced JQL and allow for date comparisons to take place like this one to get the results that you want https://marketplace.atlassian.com/apps/1221331/enhanced-search-jql-subqueries?hosting=cloud&tab=overview 

[Aron Gombas _Midori_]

You could implement a new calculated custom field "Foobar" which receives the value "creation time plus 24 hours" right when creating the issue. It should be fairly simple using Automation for Jira or maybe ScriptRunner.

Then in JQL:

resolved < Foobar 

You could also take the Excel route and save setting up the custom field. It can be easier and you can do it for yourself without contacting the Jira admin.

[Hannes Obweger - JXL for Jira]

Hi @P Hubalová

if you're open to solutions from the Atlassian Marketplace, this would be easy to do with the app that my team is working on, JXL for Jira. 

JXL is a full-fledged spreadsheet/table view that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called “smart columns” that aren’t natively available, including time between created and resolved.

This is how it looks in action:

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click. You can also use the column across JXL's many advanced features, such as support for configurable issue hierarchies, issue grouping, sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes