Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How do I write a JQL to find all issues that haven't had a specific state change after a certain date?

SSchoepel
Contributor
January 3, 2017

I need to find all issues in a current sprint minus the ones that had a specific state prior to starting the sprint.

 

project = XYZ AND Sprint = 1 AND assignee in (user)

That gets me all that users items, but now I need to filter out this: status changed to "Ready for Closure" BEFORE 2016-12-21

 

I cannot put a NOT in there. Is there some sort of subquery I can use or is there an operator I'm missing?

1 answer

1 accepted

1 vote
Answer accepted
SSchoepel
Contributor
January 3, 2017

Nevermind, I got it. JIRA was crabby at me but the filter still functions (says "was" doesn't work with my status).

 

project = XYZ AND Sprint = 1 AND assignee in (user) and status was not in ("Ready for Closure") BEFORE 2016-12-21

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, out of office, loom, confluence, async collaboration, meeting recaps, remote teamwork, team alignment, knowledge sharing, AI-powered notes, productivity tools, workforce continuity, teamwork collection

Put your meeting notes on autopilot with Loom + Confluence

AI-powered meeting notes keep work moving even if you’re out of the office. Enjoy your well-deserved time off and return refreshed, confident you’ll catch up in no time.

Learn more
AUG Leaders

Atlassian Community Events