Filter out closed issues on board older than 14 days (but not by resolved status)

[Zara]

Hi 

Our team have a kanban board and I am trying to filter out issues that have been closed over 14 days ago.

I have seen other posts that use the resolution status. This isn't working as our workflow after dev....is 'in staging' and 'in production' - and resolved is mapped to in staging at the moment, which i need to get changed.

In the mean time i want to only show recent issues deployed into production.

Tried this, but it isn't filtering out all of them 

"status was not Closed BEFORE startOfDay(-7)"

Would really appreciate some help.

Thanks

Zara

[Prakhar Srivastav {Appfire}]

Hi @Zara

If you want to get issues closed in last 7 days then you can try this :

status changed to Closed after -7d

Regards

Prakhar 

[Zara]

Thanks very much Prakhar. So this only how me issues closed within the last 7 days, which is great, but it also excludes all the other issues in other states.

[Marc Minten (EVS)]

status != Closed OR status changed to Closed after -7d

[Ryan Fish]

@Zara

try adjusting the JQL query to include ...resolution was resolved BEFORE startOfDay(-14) to show issues that were "resolved" when the status changed to "in staging'.

[Tarun Sapra]

Hello @Zara

This will give you the issues which have been "Closed" in last 14 days.

status was not Closed BEFORE startOfDay(-14d)  and status = Closed

[Tarun Sapra]

Or use the change keyword

status changed TO closed AFTER startOfDay(-14)