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

Question

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

Ryan Fish · Answer

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

Marc Minten (EVS) · Answer

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

Zara_6mb7n2 · Answer

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.