Script for retrieving Advanced Roadmap Team members

Viktoria_qdpwmb

Hello everyone,
I spent a lot of time trying to figure out how to work with the Team field of the Advanced Roadmap plugin, so I share here some useful info.

Methods for the Team: https://docs.atlassian.com/portfolio-for-jira-server/javadoc/9.12.0/overview-summary.html

REST API (and also a useful scheme for understanding how to use methods): https://docs.atlassian.com/portfolio-for-jira-server/REST/9.15.0/teams/#/definitions/TeamDTO

Script for finding team id and name:

 com.onresolve.scriptrunner.runner.customisers.WithPlugin

import com.onresolve.scriptrunner.runner.customisers.PluginModule

import com.atlassian.rm.teams.api.team.GeneralTeamService

 

@WithPlugin("com.atlassian.teams")

@PluginModule GeneralTeamService teamService<br>

def teams = teamService.getAllShareableTeams()

if (!teams) {

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("No teams found in Advanced Roadmaps")

&nbsp;&nbsp;&nbsp;&nbsp;return

}

 

teams.each { teamId, team ->

&nbsp;&nbsp;&nbsp;&nbsp;def title = team.getDescription()?.getTitle() ?:<span>&nbsp;</span>"No title found"

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("${teamId}: ${title}")

}import

Script to check whether assignee is member of the Advanced Roadmaps Teams (particular teams) and if so, set this Team to the issue (it can be more optimized, ask chatGPT):

 com.onresolve.scriptrunner.runner.customisers.WithPlugin

import com.onresolve.scriptrunner.runner.customisers.PluginModule

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.jira.issue.MutableIssue

import com.atlassian.rm.teams.api.team.GeneralTeamService

import com.atlassian.jira.user.ApplicationUser

import com.atlassian.jira.issue.fields.CustomField

import com.atlassian.jira.event.type.EventDispatchOption

 

@WithPlugin("com.atlassian.teams")

@PluginModule GeneralTeamService teamService

 

// List of target team IDs

def targetTeamIds = [256,<span>&nbsp;</span>257,<span>&nbsp;</span>258,<span>&nbsp;</span>259,<span>&nbsp;</span>260,<span>&nbsp;</span>261,<span>&nbsp;</span>262]

 

// Map to store users by team ID (userKey of users)

def teamUsersMap = [:]

 

// Get UserManager for retrieving ApplicationUser

def userManager = ComponentAccessor.getUserManager()

 

// Get all teams

def teams = teamService.getAllShareableTeams()

 

if (!teams) {

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("No teams found in Advanced Roadmaps")

&nbsp;&nbsp;&nbsp;&nbsp;return

}

 

teams.each { teamId, team ->

&nbsp;&nbsp;&nbsp;&nbsp;// Log to check the data type of team ID

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Team ID type: ${teamId.getClass().name}, Team ID value: ${teamId}")

 

&nbsp;&nbsp;&nbsp;&nbsp;// Convert teamId to the correct type for comparison

&nbsp;&nbsp;&nbsp;&nbsp;def teamIdString = teamId.toString()

 

&nbsp;&nbsp;&nbsp;&nbsp;// Check if teamId is in the list of targetTeamIds

&nbsp;&nbsp;&nbsp;&nbsp;if (teamIdString in targetTeamIds.collect { it.toString() }) {

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def title = team.getDescription()?.getTitle() ?:<span>&nbsp;</span>"No title found"

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Team ID: ${teamId}, Team Name: ${title}")

 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Map to store userKey of users in the current team

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def usersInTeam = []

 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Get team resources (persons associated with the team)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def resources = team.getResources()

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;resources.each { resource ->

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def person = resource.getPerson()

 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Get person ID (if available)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def personId = person?.getId() ?:<span>&nbsp;</span>"No person ID"

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Get jiraUser via getDescription()

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def personDescription = person?.getDescription()

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def jiraUserString = personDescription?.getJiraUser()?.orNull()

 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Convert jiraUserString (userKey) to ApplicationUser

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def jiraUser = userManager.getUserByKey(jiraUserString)

 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if (jiraUser) {

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;def userKey = jiraUser.getKey()&nbsp;<span>&nbsp;</span>// Get userKey of the user

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;usersInTeam << userKey

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Resource ID: ${resource.getId()}, Person ID: ${personId}, Jira User Key: ${userKey}")

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}<span>&nbsp;</span>else {

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn("No ApplicationUser found for ${jiraUserString}")

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}

 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Add the list of users to the map with the team ID as the key

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;teamUsersMap[teamId] = usersInTeam

&nbsp;&nbsp;&nbsp;&nbsp;}

}

 

// Log the users in teams map

log.warn("Users in teams: ${teamUsersMap}")

 

// Get the issue key

def issueKey =<span>&nbsp;</span>"TEST-1111"  // Replace with the real issue key

 

// Get the issue by key

def issueManager = ComponentAccessor.getIssueManager()

MutableIssue issue = issueManager.getIssueObject(issueKey)

 

if (!issue) {

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Issue ${issueKey} not found")

&nbsp;&nbsp;&nbsp;&nbsp;return

}

 

// Get the assignee of the issue

def assignee = issue.getAssignee()

 

if (!assignee) {

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("No assignee found for issue ${issueKey}")

&nbsp;&nbsp;&nbsp;&nbsp;return

}

 

// Get the userKey of the assignee

def assigneeUserKey = assignee.getKey()

 

// Check if the assignee is in any of the teams

def isAssigneeInTeam =<span>&nbsp;</span>false

def targetTeamId =<span>&nbsp;</span>null

teamUsersMap.each { teamId, users ->

&nbsp;&nbsp;&nbsp;&nbsp;if (assigneeUserKey in users) {

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Assignee ${assigneeUserKey} is in team ${teamId}")

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;isAssigneeInTeam =<span>&nbsp;</span>true

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;targetTeamId = teamId<span>&nbsp;</span>// Store the team ID

&nbsp;&nbsp;&nbsp;&nbsp;}

}

 

def targetTeam = teams[targetTeamId.find { it in teams.keySet() }]<span>&nbsp;</span>// Get the team by ID from targetTeamIds

 

if (isAssigneeInTeam) {

&nbsp;&nbsp;&nbsp;&nbsp;// Get the custom field Team (customfield_11111)

&nbsp;&nbsp;&nbsp;&nbsp;def customFieldManager = ComponentAccessor.getCustomFieldManager()

&nbsp;&nbsp;&nbsp;&nbsp;CustomField teamField = customFieldManager.getCustomFieldObject("customfield_11111")

 

&nbsp;&nbsp;&nbsp;&nbsp;if (teamField) {

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Update the Team field with the team ID

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;issue.setCustomFieldValue(teamField, targetTeam)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;// Use EventDispatchOption to update the issue

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;issueManager.updateIssue(ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser(), issue, EventDispatchOption.ISSUE_UPDATED,<span>&nbsp;</span>false)

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Team field (customfield_11111) updated with team ID: ${targetTeam}")

&nbsp;&nbsp;&nbsp;&nbsp;}<span>&nbsp;</span>else {

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Team custom field (customfield_11111) not found")

&nbsp;&nbsp;&nbsp;&nbsp;}

}<span>&nbsp;</span>else {

&nbsp;&nbsp;&nbsp;&nbsp;log.warn("Assignee ${assigneeUserKey} is not in any of the target teams")

}import

Brant Schroeder

@Viktoria Thanks for sharing.