JQL filter - two SLA's

Jeferson Carlos dos Santos

Hi guys, could you help me please?
I'm trying to create a filter in jql to capture 2 SLas with violated status.
But when I put the AND between the 2 slas, the filter doesn't return anything, but I know that both have violated tickets.
If I use just one sla in the filter, it works, but if I add 2 it doesn't bring anything.
Can you help me please? ( SLA 1 = T. Resolução 8h-17h, SLA 2 = T. Resolução 9h-18h )

Thats the query:

project = QTHD AND "Complexidade[Select List (multiple choices)]" in (Simples, Moderado, Avançado) AND created >= -7d AND assignee in (631254c99794410874c65725, 627abf09694943006f34c127, 631254c809bc6014ea8b8ced, 62f51a0e96eb272011aab4af, 6409e7de0a4a47fb8d252bf5) AND "T. Resolução 8h-17h" = breached() AND "T. Resolução 9h-18h" = breached() ORDER BY created DESC

Mark Higgins

Hi Jeferson,

Just so I understand you would like issues to returns that have breached two SLA's.

In your select statement there is:

Project = "QTHD" and Field in (list) and created < -7d and assignee jn (x,y,z) and an SLA that has '8h-17h' has breached and an SLA that has '9h - 18h' has breached()

So, when you have one or the other SLA then rows are returned, but when you have both, its empty?

I assume you are looking for issues that have breached both SLA's? and that  you can see issues that that appear in both queries?

If you tried (SLA 1 OR SLA 2), does it being back both sets?

 

Mark