Jira query: Closed no older than 10 days

natalia.kozik December 2, 2021

Hi everyone,

How can I change the below query, so it shows all statuses and (closed task should be hidden if older than 10 days)?  

project = CBO AND issuetype = "Project Issue" AND status in (Backlog, Closed, "In Progress", "To Do") ORDER BY created DESC

Many thanks in advance.

p.s I am using the cloud Jira version.

Nat :)

1 answer

0 votes
Antoine Berry
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 6, 2021

Hi @natalia.kozik ,

This should work based on the resolution date : 

project = CBO AND issuetype = "Project Issue" AND (status in (Backlog, "In Progress", "To Do") OR (status = Closed and resolutiondate >= -10d)) ORDER BY created DESC

You could replace resolutiondate with created or updated depending on your requirement.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events