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- · Accepted solution]

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/ 

[Pasi Pönkkö]

Hi,

the problem is that you can't compare two fields in JQL. for the lookup. What I need is something like:

"Reported hours" > "Story points"

[Marc -Devoteam-]

Hi @Pasi Pönkkö 

What you could do is create a custom field, then based on you rule, without the look up do a compare and set this custom field.

I suggest to use a number field.

Then have another scheduled automation that finds the issues based on the custom field value and then email this as a list.

In a single rule, your requirement can't be executed, using 2 rules it can be done,

[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.