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

[Mathias Mohrs]

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 :-)

[Kalyan Sattaluri · Accepted solution]

Please try below and see if results match your needs:

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

[Mathias Mohrs]

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]

@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]

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

[Kalyan Sattaluri]

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.

[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:

• https://university.atlassian.com/student/activity/1225443-intro-to-jql-in-jira-software-course-description
• https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql
• https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/

Kind regards,
Bill