FIND TICKETS WITH ETA SOON TO EXPIRE

Daniel Bermudez March 4, 2024

Hello, I need to find a query or some way to identify the tickets that are close to expiring in terms of their ETA.
That is, I have 5 tickets with an ETA for 5/3/24 and today is 4/3/24.
I need to find a query or some method to identify and group these 5 tickets that are close to expiring.

Similarly, I need to do the same for tickets whose ETA has already passed.

2 answers

0 votes
Uday Kiran Bhaviri
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2024

You can use remaining()

This filters issues whose SLA cycle's clock meets a specified time condition before the issue will breach an SLA goal.

For more information on using the SLA s in JQL queries

https://support.atlassian.com/jira-service-management-cloud/docs/write-jql-queries-for-slas/

if you want to find issues that will breach their resolution target within the next two hours, use this query:

"Time to resolution" < remaining ("2h")

Daniel Bermudez March 5, 2024

The thing is that my clients dont use SLA
What they do is when they are going to work a ticket, they have a date custom field named: ETA
In that custom field they select for example: 2/5/2024

That means that the ticket needs to be done before 2/5/2024

And they want a filter that allow them to find all those tickets that are soon (1/2 days) to expire and the ones that are expired already today 3/5/2024 

0 votes
Dan Breyen
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 4, 2024

Hi Daniel, you should be able to do something like this with an Automation..  I'm no expert on it, but there are two template Automations on this page that could probably be tweeked to check for those types of tickets and act accordingly.  Manually, you should be able to create a JQL ticket.  I'm using the Updated field, but your JQL would be something like "updated <= -5d and status != Closed" and change the operators around for the past ETA.

There's a couple of options, but that's something to work with.

Hope that helps.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events