Automation rule to create multiple subtask based on user picker (multiple users)

[Helen]

My issue has a "User Picker (multiple users)" called "Reviewers". I'd like to write an automation rule to create a subtask for each user in Reviewers and set that user as the assignee.

I have written a manually triggered rule which works when there's only one person in the Reviewers field. However, I need to be able to iterate over each user I think, and I can't work out how to do that.

Any suggestions for Jira Data Center would be gratefully received.

[Bill Sheboy · Accepted solution]

Hi @Helen 

Unfortunately, Jira Data Center does not have the Advanced Branching over smart values feature as that would make this easy.  Here is the suggestion to add that feature, which you may watch / vote for to see progress: https://jira.atlassian.com/browse/JIRAAUTOSERVER-749

There are at least two workarounds using automation rules:

#1) Use the REST API bulk-issue create endpoint

• Using smart values and list iteration, build a JSON expression to bulk-create the subtasks, storing the JSON with Create Variable 
• Call the bulk-issue create endpoint using the Send Web Request action 

In my opinion, this is the better approach as it is less likely to fail due to rule looping.

#2) Use a recursive rule with the Incoming Webhook trigger

• With your current rule, gather the user information, and use the Send Web Request action to "call" another rule, passing the user data and parent issue's key
• Create a second rule with the Incoming Webhook trigger 
  • In this rule, receive the data for the users and parent's key
  • Branch to that parent with JQL on the key, adding the subtask with an assignee
  • Remove the user from the list, and
  • Check if there are any remaining users to process
  • If so, call the rule recursively with Send Web Request with the remaining users

This two-rule approach is susceptible to multiple possible failure points, and so the #1 approach is better.

Kind regards,
Bill

[Helen]

Thanks Bill, the option of a bulk create via the REST API hadn't occurred to me. That seems like a good option - definitely more robust than the recursive rule. I'll give it a try.

[Nacho Moreno Ortega]

Hi @Helen ,

I am Nacho and i am part of Decadis.

You can achieve the desired behavior by using our app Jira Workflow Toolbox as mentioned by Christos.

To do so, a JWT automation rule can be created with the following configuration:

Expression from the issue details in which "NNNNN" must be modified for the id of the Reviewers custom field.

toStringList(%{trigger.issue.cfNNNNN})

You can easily decide when these subtasks will be created, for example when a field is updated or a transition is completed.

It is also possible to add a condition or validator to restrict the issue creation depending on your needs.

If you need any kind of assistance in the creation, please do not hesitate to contact us via our Support portal .

Best regards,

Nacho

[Christos Markoulatos]

Hi @Helen 

it should work on DC also. just copy the smart value to the assignee

[Bill Sheboy]

Hi @Christos Markoulatos 

The Advanced Branch is not supported for Jira Server or Data Center automation, and thus this approach will not work.  Here is the suggestion to add the feature:

https://jira.atlassian.com/browse/JIRAAUTOSERVER-749

Kind regards,
Bill

[Christos Markoulatos]

Hey @Bill Sheboy you are absolutely right, correct be if im wrong but u can achieve the branching functionality with JWT or JMWE if u have these 3rd party apps in DC.

[Bill Sheboy]

No doubt there may be marketplace apps to fill that need for Data Center, and I was describing above how to do it with the built-in features...until that branch is added for DC (which seems unlikely given the upcoming sunset of DC support).