How to manipulate SLA Time and Status data using JQL
- Stepan Fedortsiv_SaaSJet
- Kateryna_v_SaaSJet_ (Deactivated)
- Mariana Pryshlyak (Unlicensed)
- Danylo Ostapov (Deactivated)
Before starting, you have to make sure, your SLA is synchronized with Custom fields.
Please check the Documentation here - Custom Fields in the SLA setting
1. If data is synchronized successfully, and you can see the SLA Status and Target date in the issue layout, start from the 2nd item.
2. Then, using the name of the SLA Configuration Goal, type it in the JQL fields to create the Filter.
Pay attention! Users without access to private project can see the sensitive information in JQL.
So, by the following request, you will get the list of issues that are under the particular SLA and its Goal.
"SLA status for Time to Resolution" != EMPTYIn this particular case field name = “SLA status for Time to Resolution”, and it’s getting SLA status once any changes in the issues. So, it’s always relevant and synchronized.