JQL for calculate SLA

[Petru Negrusa]

"Hello everyone.
I have a problem with SLA. Specifically, I have 70,000 tasks, and I am creating an SLA for the project based on priority, but it doesn’t calculate until the end — it stops at about half (+/-), and the bar freezes (meaning it doesn’t finish the calculation) — you can say it hangs. I am thinking of calculating not for all tasks but for only 10,000, for example. Could you suggest a JQL code that would cover a 3-month period? I’m thinking of using created >= -90d, but I’m not sure if it will calculate from 11.09.2024 and beyond, and tomorrow it will already calculate from 12.09.2024. So, will the SLA for the tasks from 11.09.2024 remain calculated?"

[Marc - Devoteam · Accepted solution]

Hi @Petru Negrusa 

Using the JQL you proposed yes, this will take the next day as you mention.

Use the required date in your JQL.

"created >= 2024-09-11"

Also in relation to the SLA changed hanging, check the server logs what could be the reason.

[Petru Negrusa]

Thanks @Marc - Devoteam