Monitor the project without updating

Webert

Hello,
In Jira Automation there is a JQL query template for issues with more than 5 days without update:
"updated <= startOfDay(-5d) AND statusCategory != Done"

I would like to run a JQL search for Projects with more than 5 days without update, that is, all projects that have not had any updates for 5 days (tasks, subtasks, etc).

Can anyone help me with this JQL?

Thank you very much!

Darryl Lee

Hi @Webert - your JQL is just fine. The trick is where you use it.

If you use the Lookup issues action block you can create an email for each distinct project, including a the project's name, key, and link. Here's what I came up with:

The {{lookupIssues}} smart value includes all issues found in the JQL query. But if you add .project to that smart value, it only returns the project object for each issue. If you then add the .distinct function, it will remove any duplicates.

So we use the use the {{#}} list operator to iterate through all of the distinct projects found in the lookup to generate HTML code that creates a link to each project (based on the project {{key}}), with the link text made up of the project {{key}} and {{name}}. The text of the email is copied here for easier modification and reference:

The following projects have not had any updates in the last five days:

<ul>
{{#lookupIssues.project.distinct}}<li><a href="https://MYSITE.atlassian.net/browse/{{key}}">{{key}} - {{name}}</li>{{/}}
</ul>