Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,560,302
Community Members
 
Community Events
185
Community Groups

JQL for Time to First Response

Gabriela Serratto
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 26, 2023

Hi All,

Is there any way I can create a filter that shows me only the tickets that have a specific SLA goal?

For example, I want to see all issues with the Time to First Response SLA Goal set to 15 minutes.

It's not relevant information (for me) if they've breached the SLA or how long they took to be actioned on.

 

Appreciate your help!!

3 answers

0 votes
Kateryna_v_SaaSJet_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
Apr 30, 2023 • edited

Hi @Gabriela Serratto 

I recently wrote an article about “16 Most Popular JQL Filters for SLAs in Jira Cloud”. Check it out. I think there will be more useful options for you, but, in my opinion, this is the most relevant to your request:

"Time to First Response" = paused() OR "Time to First Response" = breached() OR "Time to First Response” = running()

A more straightforward way is using third-party add-ons, such as SLA Time and Report for Jira (developed by my team). Because there, you can open the dashboard “Grid table report” and filter all issues by selecting SLA and all required statuses or other parameters.
sla time and report issue filter.png
I hope this helps you.

0 votes
Joseph Chung Yin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 26, 2023

@Gabriela Serratto -

Hi Gabriela:

Welcome to the community.  You may want to consider the following to obtain what you wanted.  

1) As part of the SLA configuration goal setup, you typically uses specific JQL to apply the specific Time Goal against the issues that fit the JQL criteria.

2023-04-26_9-55-29.png

2) Example - If I want to find all the issues where "2h" time goal is applied for Time to first response event, I can simply re-use the same JQL to obtain all the issues that have this specific time goal assignment (i.e. issuetype = Incident)

You will just need to find the JQL configuration in your JSM project's SLA setup - Project settings >> SLA

Hope this makes sense.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

0 votes
Ajay _view26_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 26, 2023

Hi @Gabriela Serratto 

Welcome to the community!

You can very well use a JQL with the SLA name 

"Time to First Response" = running() 
Gabriela Serratto
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Apr 26, 2023

Thanks for replying Ajay.

 

This query only returns me the tickets that still have the SLA count running despite the SLA goal time.

I need to see all tickets (closed or not) that have the SLA goal time set to 15 minutes (breached or not).

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events