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!
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear @Darryl Lee
Your guidance worked just perfectly!!!
Thank you very much indeed for the support.
I only made a small insertion closing the <a> tag of the link, because if it is desirable to insert some content below the e-mail, the link does not extend.
Standing as follows:
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}}</a></li>{{/}}
</ul>
My best regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.