Use automation to sum up story points for an epic but only for stories that are not rejected

Michaela Kelle-Emden
Contributor
October 25, 2024

Hi,

I kow the automation to sum up the story points of all issues of an epic and write them into the story point field of the epic.

The problen is that I do not want to sum up all story points. I wont to exclude the story points of the issues that are rejected.

Do I need to add this to the "Lookup issues":

parent={{triggerIssue.parent.key|"null"}}

How?

Or do I need to extend the "Then" part:

{ "fields": { "Story Points": {{lookupIssues.Story Points.sum|0}} } }

 

Is it possible at all?

 

Regards,

Michaela

2 answers

1 accepted

2 votes
Answer accepted
Michaela Kelle-Emden
Contributor
October 25, 2024

I found the solution by myself and it is so simple.

I just needed to extend the Lookup issues to:

parent={{triggerIssue.parent.key|"null"}} AND status!=Rejected

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 26, 2024

Hi @Michaela Kelle-Emden -- Welcome to the Atlassian Community!

Well done solving your own question!  And...

In your original question, you asked how to "sum up the story points of all issues of an epic..." and you tried to find the child issues of the epic with this revised JQL:

parent={{triggerIssue.parent.key|"null"}} AND status!=Rejected

However if the trigger issue has no parent, that JQL will find ALL issues which do not have a parent, regardless of issue type.  How are you preventing that case?

Usually a rule like this is written as:

  • trigger: some trigger
  • condition: issue type is one of Story, Task, Bug, and other types you have that could be children of an Epic
  • condition: parent is not empty
  • action: lookup issues with JQL of
    • parent={{triggerIssue.parent.key}} AND status!=Rejected
  • ...

or

  • trigger: some trigger
  • condition: issue type is one of Story, Task, Bug, and other types you have that could be children of an Epic
  • action: lookup issues
  • smart values condition to confirm the lookup found any issues
    • first value: {{lookupIssues.size}}
    • condition: does not equal
    • second value: 0
  • ...

 

Kind regards,
Bill

Michaela Kelle-Emden
Contributor
October 28, 2024

Hi Bill,

Thank you!

Your first suggestion is acutally what I do. 

Regards,

Michaela

 

Like Bill Sheboy likes this
0 votes
Jovin
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 25, 2024

Hey @Michaela Kelle-Emden 

Should be achievable, just depends on the individual configuration you have. Can you help me with understanding the below:

  1. How do you identify a "Rejected" issue?
  2. Are you looking to sum the story points onto the Epic?
Michaela Kelle-Emden
Contributor
October 25, 2024

1. by the status of the issue

2. yes

Like Humashankar VJ likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events