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

A filter for issues created last 7 days and did not updated last 7 days

Elif Alverson

Hello,

This is the filter I came up with however I dont think it is working. Any idea what needs to be changed?

project = IT and created >= -7d and updated <= -7d and status not in ( Resolved , Closed )

Thank you.

Elif

Accepted answers

All comments

Stephen Deutsch

Hi Elif,

The syntax of your query seems OK (although you may have to surround the -7d in quotes: "-7d"

However, the logic of your query might not be what you want. The act of creation of a ticket is also included in the updated date, so by that logic, any ticket created in the last 7 days will have been updated in the last 7 days.

This might be closer to what you're expecting:

project = IT and created >= "-7d" AND NOT status changed

This would find all tickets that have been created in the last 7 days that have not yet made a transition.

Elif Alverson

Stephen,

Thank you for your response. We would like to see the tickets created in last 7 days and never been updated since they are created. Most of the time IT tickets are being updated without the workflow status changed. IT engineers contact to reporters asking questions about the issue using the comments field in Jira and they don’t change the status of the ticket. Is there any way to capture that?

Elif

Stephen Deutsch

It won't work out of the box, but if you install the JIRA Toolkit Plugin (or make sure it's enabled if you are using Cloud), then the following query should work:

project = IT and created >= "-7d" AND NOT status changed and "Number of comments" > 0

Elif Alverson

Stephen,

What is I use this filter below. Do you think it works?

project = IT and created >= "-7d" and updated <= "-6d" and status not in ( Resolved , Closed )

I am confused about the " updated " statement for the jira filters. If it does not include the workflow transitions , what does it include? I thought every update done to an issue can be capture with " updated" statement.

Thank you.

Jason Ambrose

issueFunction in lastComment("before -7d") and created >= -7d

Karmandroid Singularity

try with "created >= startOfDay(-7d)"

John Corwith

I just had to do this and pieced together something that works for Enterprise and wanted to post it so others don't have to spend time piecing it together:

AND created >= -7d AND NOT updatedDate >= -7d

will give you issues that have been created in the last 7 days and haven't had a status change or comment in the last 7 days which was the original intent of the question.