Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,727
Community Members
 
Community Events
168
Community Groups

Add number of linked issues to the custom field

Hi ๐Ÿ‘‹ ,

I'm trying to create automation rule in Automation for Jira where a number of linked issues would be stored in the custom field.

My use case:
I have a Project with customer feedback with 2 types of tickets - Suggestions (stuff that our customers raise) and Improvements (Stuff that we're delivering to solve customers suggestions).
We link Suggestions to Improvements to keep track of which of the improvements are most popular and also to make sure we know who raise them.

Now for that, I created custom field Raised (total) where I want to store how many times Improvement was raised = How many linked issues this improvement has.

Here is what I have done in Jira automation so far:
Screenshot 2020-09-23 at 09.29.38.png

1. My trigger is when Issue is Linked to the ticket
2. Then I store an issue key as {{issuekey}}
3. Then I use Lookup issues with this JQL issue in linkedIssues({{issueKey}})

4. Then I Edit issues field Raised (total) with {{lookupIssues.issue.count}}

 

It doesn't seem to work, any suggestions on how to improve? Did anyone tried something similar? :)

 

Thank you!

1 answer

1 accepted

0 votes
Answer accepted
Dirk Ronsmans Community Leader Sep 23, 2020

Hi @Nikki Zavadska _jexo_ ,

You mention "it doesn't work", do you get any errors on the automation or just nothing happens?

What exactly do you put in your variable?

For one you could already change the JQL you use (without knowing what's in the variable) This could just be replaced with

issue in linkedIssues({{issue}})

did some testing.. and had to rework the structure a bit.

Mine currently is:

 

image.png

this will basically do the query that we want (I think?, to see how many items are related to and you could even only run the rule if the issue type is Suggestion) and then I changed the edit field to:

{{lookupIssues.size}}

That works for me!

Thanks @Dirk Ronsmans for your help!

I did adjust the rule in the way you mentioned and it worked! I just removed the variable because it wasn't needed and {{lookupIssues.size}} as a value instead of {{lookupIssues.issue.count}}.

Here is the final rule for anyone else reference if needed :)

Screenshot 2020-09-23 at 16.18.53.png

Like โ€ข # people like this

Hello @Dirk Ronsmans 

I need to perform the same calculation but the suggested rule didn't work for me.

I have a support ticket (issue type A) in project AA, and bugs and change requests (issue type B, C) in project B.

Each time I link a support ticket to a bug/CR, I need a field in the bug/CR tickets that counts the number of linked support tickets to that bug/CR.

I tried the last shared rule, but I got 0 always.

Do you have a suggestion?

Thanks

Similar ask, I wanted to get the linked issue keys(multiple) and to add those KEYs in comment section. Could you please give some tips?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Atlassian Automation

Jira Automation: Sum Up Story Points Roundup (Initiatives -> Epics -> Story/Tasks -> Subtasks)

Hi Everyone, In this roundup we combine all the jira automation rules to sum up story points across different issue types. We start from the lowest level, summing up story points from sub-tasks t...

3,119 views 10 9
Read article

Atlassian Community Events