Forums

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

I need to set my filter to only show items that had their status set to closed past a certain date

Nor Habboub
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
February 3, 2021 edited

I had this filter "created >= 2021-01-01", which didn't show past items that were created earlier but closed within the past month. I'm trying to set a filter like this "status = ("Closed - No Action") >= 2021-01-01" to focus only on items closed in the past month regardless of when it was created, which isn't valid. Is there any way to fix this?

2 answers

0 votes
Martin Bayer [MoroSystems, s.r.o.]
Community Champion
February 3, 2021

Hi @Nor Habboub , welcome on the community. There are "historical" operators in JQL for status field. I think this query should work for you (will display issues whose status was changed to Closed after start of current month:

  • status changed TO Closed AFTER startOfMonth()

I found an article with short description here: https://moduscreate.com/blog/historical-operators-jql-search/

0 votes
Pramodh M
Community Champion
February 3, 2021

Hi @Nor Habboub 

The JQL goes like this

status changed to closed AND updatedDate <= -3d

This results in issues where the status was changed to closed, more than 3 days back.

You can also specify the date here.

Thanks,
Pramodh

Italo Qualisoni [e-Core]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 3, 2021

My suggestion is to use BEFORE , so you will get all issues that transition to closed before your specific date.

status changed to closed BEFORE 2021-01-01

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, state of product 2026 webinar, product team report, webinar, product management, ai productivity, agile practices, team alignment, product report, atlassian learning, product strategy, discovery to delivery, survey insights

Webinar: State of Product 2026

We asked real teams how they’re coping with an industry in flux. Join this webinar to hear the research –plus tips for leveling up your team’s work.

Register now
AUG Leaders

Atlassian Community Events