Automation - lookup issues that are Done

[Levine]

I'm a JQL newbie and trying to modify an existing automation ("When the story point estimate for an issue is changed → sum up story point estimates in Epic") to update a field with the number of story points completed. 

To do this, I believe I have to update the Lookup issues function (parent={{triggerIssue.parent.key|"null"}}), but I have no idea how to only search for issues with Status = Done. 

I feel like this should be relatively straightforward, I'm just not familiar w/ this particular syntax.  Any thoughts?

[Walter Buggenhout · Accepted solution]

Hi @Levine and welcome to the Community!

There is something strange about your use case. From what you describe, it seems you want to track the number of story points completed. But that seems something you would do when a story is actually completed, rather than after you update a story point estimate.

If I understand your use case correctly, I would rather automate it like this:

In short:

• WHEN a story transitions to Done
• Check if it has a parent epic
• Then, for that Epic lookup all its child issues ("Epic link" = {{issue.key}} AND Status = Done) 
• and update a field Story points completed in your epic using {{lookupIssues.Story Points.sum}}

In the example above, I used the Story Points field as an example. That's just because I don't have a specific field set up for points completed in my test instance. Definitely set up a different field for that.

Hope this helps!

[Levine]

Thanks for the response, Walter!  I should have clarified that I already had a condition looking for when a ticket was moved to Done.  That said, I think your approach is cleaner, so I experimented w/ that.

At this point, the automation runs, but it's still not summing the story points in the target column.  Here's my automation:

And here's the results on the epic:

As you can see, Test 1 is marked as Done, but the Completed Story Points remains 0.  Audit said the automation worked, any ideas what could be the issue?

[Trudy Claspill]

What does the Audit Log show for the execution of the rule? Notice the Audit Log option above the Rule steps, below the rule title and link to the Rule Details page.

Can you confirm for us that you are indeed working with issues in a Team Managed project?

I actually was just constructing this same rule in response to another post, and I found that it didn't work if I used Epic Link in the Lookup Issues action. Instead I had to use Parent.

[Levine]

Parent did it - thanks for all the help!!!

[Trudy Claspill]

I'm glad we could help you!

If your problem has been solved, please consider marking the Answer thread as Accepted to help other users find posts with working solutions.