Work Log Monthly Email using Jira Automation

[Aleena Umaiir]

I am working on a task, I want Jira to send an automated email at the start of month to the user.

The email should contain all the issues that user has logged work on, I used this query

worklogDate >= startOfMonth(-1) AND worklogDate <= endOfMonth(-1)

and following email body:

{{#issues}} - [{{key}}] {{summary}} - Time Logged: {{worklog.timeSpent}} {{/issues}}

but with this, I am getting multiple emails for each issue, I want to include all issues in one email, where I am wrong here?

[Sarp Egemen · Accepted solution]

Hi @Aleena Umaiir ,

As the warning in your screenshots also states, the action will be executed for each issue matching the JQL. That's why you receive an email for each matching issue.

You can still use automations, but I believe what you are trying to achieve is already a feature of Jira called "Filter Subscriptions." You can save any filter and then subscribe a group (or user) to receive those issues in a periodically timed email, similar to the format you mentioned.

Here you can find more about filter subscriptions: link 

Here is an example how a filter sub. looks like as an email:

[Aleena Umaiir]

@Sarp Egemen It was so simple and I was using automation and all. 

Anyways, both methods worked but I am liking Filter format very much. 

Thanks a lot!

[Aleena Umaiir]

@Sarp Egemen can we take a sum for all of these "Time Spent" records and show at the end? Any feature like this?

[Vishal Biyani · Accepted solution]

@Aleena Umaiir 

Can you share the screenshot of your automation to better understand where the issue could be?

[Aleena Umaiir]

[Aleena Umaiir]

@Vishal Biyani  here you go, please look into it

[Vishal Biyani]

Can you describe your problem in some more detail?

As per the SS, automation will trigger at scheduled time and send one email.

it doesn't look like this will send multiple emails.

[Aleena Umaiir]

I am receiving multiple emails, each email has one issue,

I want all issues to be placed in one email, below is the ss of the one of the multiple emails I received

[Vishal Biyani]

in that case take out the JQL from Scheduler.

After Scheduler add an action lookup with the JQL that is currently inside scheduler.

Then in the email iterate over lookupIssues. 

This should resolve the problem in my opinion.

This is how the automation will look like

The email body should have something like this:

{{#lookupIssues}} - [{{key}}] {{summary}} - Time Logged: {{worklog.timeSpent}} {{/}}

Let me know how it goes for you

[Aleena Umaiir]

Thanks @Vishal Biyani it worked.