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

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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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 Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
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