Status updated in the last 2 weeks

Question

Hi All

I'm trying to create a column in the board that will show me closed status issues that have moved to this status in the last two weeks, for some reason it also shows me statuses from a year ago in closed status

I try to do this:

project in ("X","y") AND created >= 2020-01-01 or status != Closed and (status = closed and resolutiondate >=-14d) order BY created DESC

Idan Naamad · Answer

that's what i did and finally worked.

thanks anyway.

project in ("X") AND created >= 2020-01-01 AND status = closed AND statusCategoryChangedDate > -2w OR project in ("X") AND status != Closed AND created >= 2020-01-01 ORDER BY created DESC

Idan Naamad · Answer

Thanks,

The thing is that i want to see all Statuses, the "closed" status i want to see only last 2 weeks

Mehmet A _Bloompeak_ · Answer

Hi @Idan Naamad ,

The "or" inside the jql results in getting 1 year old issues. Use the below instead

project in ("X","y") AND created >= 2020-01-01
and status = closed and resolutiondate >=-14d order BY created DESC