Query for all unresolved JIRAs at the end of last week or...

[Pete Rooney]

...the start of THIS week.

1. Project = MYPROJ AND Status not in (Closed, Cancelled) on EndOfweek(-1w) AND Created < StartOfWeek() ORDER BY key DESC

errors with:

Error in JQL Query: The NOT_IN operator does not support the use of the on EndOfweek(-1w) predicate

2. Project = MYPROJ AND Resolved was empty on StartOfWeek() ORDER BY key DESC either...

errors with:

History searches do not support the 'Resolved' field.

Any thoughts, wise folk? - thanks - Pete

[Pete Rooney · Accepted solution]

Sorted!

Project = MYPROJ AND Resolution was EMPTY on StartOfWeek() AND Created < StartOfWeek() ORDER BY Key DESC

[Flavien Gache]

For the second query, you need to change Resolved by Resolution :)