Tickets createds and resolveds in weekend

[Josep María Cao]

Hi guys, i'm trying to do 3 jql with the following result

1. Tickets that are created during the weekend

2. Tickets createds during the weekend and resolved in the weekend

3. Tickets createds during the weekend but not resolved in the weekend. 

So the sum of the 2 and 3 should be the same number as the filter 1.

I have the nexts JQLs:

1. created >= startOfWeek(-39h) AND created <= startOfWeek(1d)

2. created >= startOfWeek(-39h) AND created <= startOfWeek(1d) AND resolutiondate >= startOfWeek(-39h) AND resolutiondate <= startOfWeek(1d) 

3.  created >= startOfWeek(-39h) AND created <= startOfWeek(1d) AND Store is not EMPTY AND status not in (Closed, Resolved)

The first two JQLs are correct, but the third one is incorrect because i have to show the issues that were not resolved in the weekend and is displaying tickets that are resolved after weekend and i don't know how to do it. 

Can you help me please?

Thanks

[Antoine Berry · Accepted solution]

Hi @Josep María Cao ,

Looking at your requests, this is how I would do it : 

created >= startOfWeek(-39h) AND created <= startOfWeek(1d) AND (resolutiondate > startOfWeek(1d) OR resolution is empty)

Let me know if that helped.