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?
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:
@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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Sarp Egemen can we take a sum for all of these "Time Spent" records and show at the end? Any feature like this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you share the screenshot of your automation to better understand where the issue could be?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
After lookup I added "Create Variable" to store totalTime of all issues as but I am not able to keep a value in it with each record of the lookup.
Does Jira automation allow this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
lookupIssues can be looped through to get sum of values.
Could you share the rules/calculations that you have put so far and what issue you are facing? that will give better understanding of the issue you may be facing.
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.