Get the list of SLA Breached / not Breached tickets from jira database

Hi All,


I am looking to get a list of SLA Breached/ Not breached tickets from JIRA database. Its a Json field and we are using Oracle 11. Looks like there is good support for JSON in oracle 12.

I could find the breached/ Not breached for the closed tickets by looking for "completeSLAData":[{"succeeded":false' or "completeSLAData":[{"succeeded":true in the customfieldvalue.

But it is not clear for the open tickets as we also have an option to move tickets between types and some types have sla set up and some not.

Is there a way to get what the breached() function actually does as it seem to get right results in JQL which is exactly what i am looking to do from database?


Many Thanks in Advance


1 answer


This is a little bit more complex than it looks to be sad

For completed (Finished) SLA Metrics you can read data directly from database, but for Active and Paused metrics SLA Metric Searcher uses some logic. To determine if an Active SLA Metric is breached you need to determine: SLA Calendar, Consumed time, SLA Goal Value and current time.

It can't be read directly from database but you may write some code to map entire logic and get actual SLA Metric values. We did it some time ago for VertygoSLA (it took a lot of time but it's feasible).

If the reporting is essential to your company, you can use SLA PowerBox add-on which provides SLA Date custom field type and let you get data directly from database (but it's paid add-on and replaces SLA functionality in JSD).

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

800 views 2 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you