Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

...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

2 answers

1 accepted

2 votes
Answer accepted


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

1 vote
Flavien Gache Community Leader Nov 30, 2020

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

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events