get tickets list with no transition to "Qualified" after 1h AFTER the creation

[Guillaume Chazerans]

dear all

I know how to search any transaction changes AFTER a specific time from now.

Is there any possibility to search all ticket for whiches there is no transaction to specific status during the first hour AFTER the creation?

I would like to use this kind of request:

status changed to qualified during( created, created +1h)

Thanks for your help

Guillaume

[Parvaneh Zand]

Hi @Guillaume Chazerans 

You can set SLA if  your project is a Jira Service Desk type. Start point would be the first status after creation, and stop point is 'qualified'!

you can read more here:

https://confluence.atlassian.com/servicedeskserver/setting-up-slas-939926373.html

otherwise, you need to create a Scripted Custom Field to display a calculation on an issue, I mean [for example Sum of Time to Resolutions] since the first transition, and comparing the result with 1 hour!

then simply search for requested issues by JQL.

https://community.atlassian.com/t5/Jira-questions/script-to-calculate-time-since-created-date/qaq-p/41488