nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Compare estimate and reported hours to a list

Pasi Pönkkö_h5k44h

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! ).

Accepted answers

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/

All comments

Valerie Knapp_gp7rpj

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ö_h5k44h

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.

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/

Pasi Pönkkö_h5k44h

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,

Pasi Pönkkö_h5k44h

Actually I'm still not able to achieve what I want

I've managed to create an automation which sends separate emails for each issue but I really want to get only one email with list of issues.

JQL and lookupissues are not an answer because you can't compare two fields with them. Any other suggestions?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

automation