Filter to record projects that have not been updated in certain time.

Question

Currently have a filter:

status != Closed AND (category IN ("xxx","xxx","xxx","etc") AND
updated <= startOfDay(-7)) AND (assignee IN (xxx,xxx,etc))

This provides me with all issues that have not been updated in a timely manner (3 days, 7 days, and 14 days) based on the category of the project and assignees.  I also tried different jira gadgets to show this information so far the best has been multiple filters line chart gadget. The issue I am having is there is no way to keep track of what issues have been previously flagged. Is there a filter that allows you to check the update time between comments?

Hannes Obweger - JXL for Jira · Answer

Hi @Jesus M.

welcome to the community!

Just to add to Fazila's answer: If you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including the last comment date (along with many other comment-related columns).

This is how it looks in action:

As you can see above, you can easily sort and filter by the last comment date, and also use it across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. All this just works - so there's no scripting or automation whatsoever required.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

Fazila Ashraf · Answer

Hi @Jesus M.

Welcome to community!

Natively there is no report on time between comments, you could create an automation that records time stamp in a field whenever a new comment is added. And also swap the timestamp to another field before overwriting the latest comment timestamp. Calculate the time diff between these 2 in a different field.

Hope that helps!