Automatic last week done tasks through email subscription

Osama Al-Areky

Hello,

Is there a way to create a filter that shows only the tasks done the last week, automatically for the subscription to receive it by mail, without determining the dates,

Thank you,

 

Bill Sheboy

Hi @Osama Al-Areky 

Yes, that is possible, and...

First thing, I recommend learning more about writing JQL queries like this.  That will help you write and maintain the queries in the future.  To learn more about that, please see this free training and documentation from Atlassian:

• 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/jql-operators/#CHANGED
• https://support.atlassian.com/jira-software-cloud/docs/manage-filters/

 

Back to your question...there are several ways to do this with JQL, save the filter, and subscribe to it and receive weekly emails.

For example, to specifically check the status values:

project = myProjectName
  AND status = Done
  AND status CHANGED TO Done DURING ( startOfWeek(-1), endOfWeek(-1) )
  ORDER BY Resolved ASC

Or, to create a filter which ignores the specific Status names, in case they change in the future, use the statusCategory fields:

project = myProjectName
  AND statusCategory = Done
  AND statusCategoryChangedDate >= startOfWeek(-1)
  AND statusCategoryChangedDate <= endOfWeek(-1)
  ORDER BY Resolved ASC

 

Kind regards,
Bill