Query that shows unresolved tickets for the past x days

Question

Hi,

Just want to know a query where I can apply as a quick filter in the Kanban board, I want to see Unresolved or no movement tickets within the past 3 days. Thanks.

tried using updatedDate <= -3d query but it shows unresolved tickets and no movements for the whole month.

Ronald Amit · Answer

Hi Kalyani,

Thanks for the reply. Actually, we just want tickets that was tagged as unresolved to show up.

We ended up using "updatedDate <= -3d", and I think that worked.

unknown · Answer

Hi @Ronald Amit,

If you only give the updatedDate in the JQL, then it may be pulling in all the issues, including Resolved issues, which may not really have an update/movement, as they already stand Resolved. I know you mentioned you are able to pull only Unresolved tickets just with the updatedDate, but not really sure how that is possible.

Have you tried including 'status not in (Resolved, ...)' along with updatedDate? You may want to include all the Statuses that need to be excluded from your query and the result-set. Or you could use 'status in ()' to include only those issues in a specific status that did not have an Update in the last 3 days.

Hope this helps!

Thanks

Kalyani