Compare estimate and reported hours to a list

[Pasi Pönkkö]

I want to build simple automation which compares two fields and if the result is true, send me a list of all the issues which resulted true. Fields are Reported hours (user's reported hours per issue) and Story points (Estimate).

I've managed to create an automation which sends separate emails for each issue but I really want to only get a list of issues (no spam! :)).

[Marc -Devoteam-]

Hi @Pasi Pönkkö 

You need a llokup for this question you have.

Then add an advanced branch in your automation, to run over the issues found in the lookup action.

Set you condition in the branch as well as teh sent mail action.

In the sent mail action, use {{#lookupIssues}} {{key}} | {{summary}} {{/}}

Also see https://support.atlassian.com/automation/kb/automation-rule-to-send-single-email-for-all-issues-per-assignee-due-next/ 

[Valerie Knapp]

Hi @Pasi Pönkkö , thanks for your post.

Please refer to this knowledge base article - https://support.atlassian.com/jira/kb/email-issues-structured-in-a-table/ 

I think it will help you.

Best wishes

[Pasi Pönkkö]

Hi,

thanks for the quick reply.

My problem is that if I use lookupissues / jql, I can't compare two fields. I think the explanation is that JQL is query and nothing more.

This is the reason I've used this approach:

This works except I get an email from each issue and I really want issues as a list.