How to monitor total story points of linked stories that linked to a user story as a User Story Val?

[cemilsarihan]

Hi Everyone,

We're trying to create an automation from Jira software to see total story points of some stories that linked to a user story. 

Normally we have same automation but Jira allows us to show epic as a parent and we can get all the remaining story points of the stories. but we could not do that for user story. 

I attached the screenshots below. 

we tried to get all linked stories and created a variable that is calculating all lookup issues and sum the story points. 

then wrote a jql to get user stories and tried to edit user story value with the new variable. but it did not worked. 

Do you have any suggestions? Thank you. 

[Trudy Claspill]

Hello @cemilsarihan 

Welcome to the Atlassian community.

1. The scope of a variable created within a branch is limited to within that branch. You can't use the variable outside the branch.

2. You can't use the {{lookupIssues}} object if you have not first used the Lookup Issues action.

3. Your branch for Linked Issues is going to look at each issue linked to the trigger issue, not all the linked issues as a group.

So there are many problems with this rule. 

Let us first get a clear understanding of what you want to happen.

When do you expect this rule to be triggered, and for which issues?

Do you want it triggered when there is a change to the issue you want to edit?

For what sort of changes do you want the rule triggered? When the issue is created? When other issues are linked to it, or linked issues are removed.

And you want the sum to be calculated based on only some of the linked issues, correct? You want to sum only the linked issues that are of type "User Story" and that have the "blocks" relationship to the issue you want to update, is that correct?

[cemilsarihan]

Hi Trudy,

We want to trigger the rule, when a new issue(story) created or an existing issue's(story) story point updated. If a story or stories linked to a user story, user story's user story value should be edited according to changes of linked issues story points. 

For example we have 3 stories (XYZ-1, XYZ-2, XYZ-3) and linked to 1 user story (ZZZ-1).

XYZ-1 3 Story Points

XYZ-2 5 Story Points 

XYZ-3 1 Story Points

Automation should look those story points, get sum of them and print to ZZZ-1's user story value as 9.

If XYZ-1's story point is updated as 3 to 1, ZZZ-1's user story value should be updated as 7.

Also if a new story is created as XYZ-4 and story point is 8, linked to ZZZ-1, user story value should be 15. Or if a story is deleted, user story value should be less. 

We're trying to set this automation. 

[cemilsarihan]

Do you have any comments @Trudy Claspill ? I set up the automation as manually triggered but if you have any automated version I would like to hear it. Thanks :)

[Trudy Claspill]

Is your manually triggered version of the rule working? Can you post a copy of that?

Can the XYZ issue have the same type of link (is blocked by) to more than one ZZZ issue or to other issues in the same or other projects? If so, do you want all the linked issues updated?

Are these issues in different projects? If you are linking issues across projects then you will have to create a multiple project rule and specify all the projects that might have linked issues matching your criteria. Multiple project rules can be created only from the Global Automations page under System settings.

Do you have any apps that extend JQL capabilities, like JQL Search Extensions of ScriptRunner Enhanced Search?