I want a JQl query all statuses tickets but except closed tickets for last week only

[Murugan Mittapalli]

Hi guys,

How to query it, i want see all statuses tickets like old or new  but except closed tickets for last week only.

Thank you.

[Petter Gonçalves]

Hello Murugan,

I think the query below should work for you:

- resolutiondate <= startOfweek(-1w) or resolutiondate >= startOfweek()

Also, you could search for tickets that were not closed in the last seven days:

 - resolutiondate <= startOfday(-7d) or resolutiondate >= startOfday()

[Kimberly Deal _Columbus ACE_]

Hi @Murugan Mittapalli

You're going to need a JQL statement that looks something like this, with changing out your Project key for JQLTEST2

project = JQLTEST2 AND status != Closed AND status changed after startOfWeek("-1") before startOfWeek()  ORDER BY created DESC

[Murugan Mittapalli]

@Kimberly Deal _Columbus ACE_ , thanks for your response, Let me give you more info, I have 10 statuses and i need all 9 statuses "OLD" all tickets but closed only for last week. 

[Kimberly Deal _Columbus ACE_]

That JQL will give you all status except closed, if your end status is something other than Closed you can replace Closed with that status.