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

Need help for a filter for "Status has not changed in the last 14 days"

Mathias Mohrs_ozw3u8

Hello, I need help with a filter!

In my project, I would like to display a filter on the dashboard that shows me all tickets that are in the project and for which the status has not changed in the last 14 days - e.g. if i have the status "Ready For Development", "In Development" and "Done" - there i would like to see if a ticket is in status "In Development" for at least 14 days without the status beeing changed to one of the other status.

What is the JQL string?

I would be very happy for help :-)

Accepted answers

Kalyan Sattaluri_iinm1n

Please try below and see if results match your needs:

project = XXXX and status = "In Development" and not status changed after -14d

All comments

Kalyan Sattaluri_iinm1n

Please try below and see if results match your needs:

project = XXXX and status = "In Development" and not status changed after -14d

Bill Sheboy

Hi @Mathias Mohrs

In addition to any other answers provided, I recommend learning about JQL and how to answer such questions with it, helping your team be more effective using Jira.

For some free training from Atlassian on JQL, please see these linked items:

Kind regards,
Bill

Mathias Mohrs_ozw3u8

Thank you all!

As @Kalyan Sattaluri said it works with "project = XXXX and status = "In Development" and not status changed after -14d".

But i also tried sth else:

"project = XXXX and status = "In Development" and not (description changed after -14d or comment changed after -14d)"

So i further wanted to see if anyone has changed the description or changed/added a comment within the last 14 days. If i try the filter Jira says:

"History searches do not support the 'description' field."
"History searches do not support the 'comment' field."

Is there a way to work that out?

Kalyan Sattaluri_iinm1n

@Mathias Mohrs the "Changed" operator can be used with the Assignee, Fix Version, Priority, Reporter, Resolution, and Status fields only, not with multi line text fields like descrption, acceptance criteria, comments etc.

Typically people use automation rules to get notified when description / comments are added or edited and dont use JQL to list items like you are looking for.

Mathias Mohrs_ozw3u8

Thank you @Kalyan Sattaluri - what can i do to achieve the desired results?

Kalyan Sattaluri_iinm1n

Sorry, as mentioned, for description etc, You cannot achieve that through native JQL where you want to filter where Description was edited/changed/added in the last N days. maybe you can look into market place add-ons if you truly want that info.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-software-cloud