Have an simple automation rule where the JQL is validated but next action will not trigger

[Ed Richard]

Need a rule where I want to send an email to anyone who closes a story but there are subtasks or other child issues still open..

The rule starts with "rule is run when an issue is updated:

then the condition is if JQL is matched and here is the JQL which does return issues if this filter is run standalone: (and I did Validate the filter in the rule and it finds issues)...

project = ERT AND issuetype = story AND status = Done AND "Planned For" = "Guardium Release 10.5" AND issueFunction in parentsOf("project = ERT and status not in (Done)")

then next action does not matter (i currently just have a comment being added) really since its not firing at all, even though the JQL is matched by at least 1 issue...I checked the log and its not executing

I am using V3.1.0 and tried obviously updating the issue multiple times in an attempt to get the rule to execute but nothing... is the JQL too complex? something else?

[andreas]

Hi Ed,

I think you should be able to achieve this with our related issues condition (https://docs.codebarrel.io/automation/components/conditions/conditions.html#related-issues).  A rule like this should work:

• Trigger: Issue transitioned
• JQL condition: type = Story and statusCategory = Done
• Related issues condition: subtasks where *some* match statusCategory != Done
• Add comment/Send e-mail

You could also use JQL in the related issues condition to find issues related to the story other than sub-tasks.

Hope that helps!

Cheers,
 Andreas

[Ed Richard]

That did work!.. thanks very much Andreas! Really appreciated it...  - Ed