Dear community, I need your support. I'd like to create following rule: * Every Thursday * Lookup issues with some filter criteria * and check if the due date of child tickets is greater than the due date of the parent epic. * Then send ONE email with all epics that have child issues which exceed the epic's due date. I tried the condition the following condition but It did not work. {{lookupIssues.parent.dueDate}} is lower than {{lookupIssues.dueDate}} Any clue how to solve that? Thanks!

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 Epic's due date with all child due dates

Maurice B.

Dear community,

I need your support.

I'd like to create following rule:

Every Thursday
Lookup issues with some filter criteria
and check if the due date of child tickets is greater than the due date of the parent epic.
Then send ONE email with all epics that have child issues which exceed the epic's due date.

I tried the condition the following condition but It did not work.

{{lookupIssues.parent.dueDate}} is lower than {{lookupIssues.dueDate}}

Any clue how to solve that? Thanks!

Accepted answers

Vishal Biyani_2pr07j

@Maurice B.

I wrote this sample rule. See if this gets you going. Assumption is if any of the child issue has a due date > than parent, then it needs to be flagged.

Therefore, I used max to simplify the logic.

All comments

Vishal Biyani_2pr07j

@Maurice B.

I wrote this sample rule. See if this gets you going. Assumption is if any of the child issue has a due date > than parent, then it needs to be flagged.

Therefore, I used max to simplify the logic.

Maurice B.

Hi @Vishal Biyani,

thank you, that check works. But with that rule, all lookup issues are displayed in the audit log. Do you know how to add only those issues that correspond to the condition?

Thank you!

Vishal Biyani_2pr07j

adding this condition

gives True if issues due date is after parent due Date otherwise it does not print anything.

This logic you can build in email template to send issues that match the condition

Vishal Biyani_2pr07j

@Maurice B.

There was slight error in the above. use this and you will get the required issue keys.

If this helps you, please accept the answer so that others can also benefit

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