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; } } }

Query to show open issues and issues closed in last x days?

roam_scott

I want my query to show all issues that are either open now or were closed within the last x number of days. Essentially, tickets closed more than x days ago will "fall off" the board/query. Here is what I have:

project = FUS AND (resolved >= -1d OR status != "Resolved") ORDER BY cf[10011] ASC, created DESC

Unfortunately I'm still seeing tickets I closed more than 1 day ago. What am I doing wrong?

p.s. ">= -1d" was generated by the simple query. I also tried "<= 1d" and get the same results.

Accepted answers

roam_scott

This works:

project = FUS AND (resolved >= -1d OR status != Done) ORDER BY cf[10011] ASC, created DESC

I thought "Resolved" was the special status that included "Done" and "Closed", etc. No?

All comments

roam_scott

This works:

project = FUS AND (resolved >= -1d OR status != Done) ORDER BY cf[10011] ASC, created DESC

I thought "Resolved" was the special status that included "Done" and "Closed", etc. No?

Alexey Matveev

What do you mean by "closed"? Resolved means that the resolution of an issue was set. If you mean by "closed", that the issue was moved to the Closed status, then your JQL query should be like this:

status changed to Closed after -1d

Ant_q87x6g

Try this...

AND status = "In Dev" OR resolved > -1d

Mahesh Kallepalli_u4afak

@Alexey Matveev

Can you help me with JQL for closed tickets up to 50 only in a single filter.

burle_chaitanya

I am not sure about JQUERRY

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

query