nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Agile filter define all human logic..

Jonas Andersson

I am working on a JQL query that shows all open issues in a project, and closed issues that were resolved the last 15 days. I state my query like this:

(project = "PROJECTX" AND resolution = Unresolved) OR (project = "PROJECTX" and (resolution = Done and resolved < 15d )) ORDER BY Rank ASC

However it still lists issues in PROJECTX that was closed for months.. Banged my head on this one for a while, can anyone see what i am doing wrong here?

Kind regards

Jonas

Accepted answers

Petar Petrov _Appfire_

Hi Jonas,

The resolved filter criteria should be "> -15d", so your filter should look like this:

(project = "PROJECTX" AND resolution = Unresolved) OR (project = "PROJECTX" and (resolution = Done and resolved &gt; -15d )) ORDER BY Rank ASC

See the documentation and examples here: https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-fields-reference-764478339.html#Advancedsearching-fieldsreference-ResolvedResolutionDateresolutionDateResolved.

All comments

Meck

Hi Jonas,

That issue was closed with what resolution value?

Petar Petrov _Appfire_

Hi Jonas,

The resolved filter criteria should be "> -15d", so your filter should look like this:

(project = "PROJECTX" AND resolution = Unresolved) OR (project = "PROJECTX" and (resolution = Done and resolved &gt; -15d )) ORDER BY Rank ASC

license management

Thank you, that worked like a charm. smile Upvoted, set as a solution. Pet yourself on the back. smile

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-core

jql