nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help -- Selection from Drop Down list updates two custom user picker fields

Jeremy Cejka

Hello Community.

Any help would be appreciated.

I have a custom field drop down list, that details three different sites,

Based on the selection of that site I have two custom fields that need to be updated with the correct people assigned to that site.

Both fields are multiple users.

if drop down siteA

then

field 1, user1a and user2a

field 2, user3a

if siteb

then

field1, user1b and user2b

field2, user3b

if siteC

field1, user1c, user2c

field2 user3c

I have scriptrunner, Ive tried a couple of existing scripts but all of them do not work, so im at a loss. Rather than muddy the water, if anyone can help me I would be greatly appreciated.

Running 8.5.4

Scriptrunner 6.17

Accepted answers

Hana Kučerová

Hi @Jeremy Cejka ,

it is not clear to me, when this automation should happen. Is it during issue creation or other transition or ... ? Something like your user just created/transitioned some issue and based on the siteA value, which is mandatory, the other fields should be changed...

Thank you for the clarification.

All comments

Hana Kučerová

Hi @Jeremy Cejka ,

Thank you for the clarification.

Jeremy Cejka

Sorry for not including this, At time of creation. This selection would occur on the create issue screen. And would be a post function trigger.

Jeremy Cejka

I started with this, not sure if its right. I kind of took pieces of scripts that kind of matched what i was trying to do.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.issue.customfields.option.LazyLoadedOption;
import com.atlassian.jira.user.util.UserManager;

def customFieldManager = ComponentAccessor.getCustomFieldManager()
def siteField = customFieldManager.getCustomFieldObject("customfield_14203")
def securityField = customFieldManager.getCustomFieldObject("customfield_14308")
def opsField = customFieldManager.getCustomFieldObject("customfield_14303")

def siteFieldValue = ((LazyLoadedOption)siteField).getValue()
def security = [] as List
def ops = [] as List

if (siteFieldValue == "ALX") 
{
security << ComponentAccessor.getUserManager().getUserByKey("user1a")
security << ComponentAccessor.getUserManager().getUserByKey("user2a")
ops << ComponentAccessor.getUserManager().getUserByKey("user3a")
log.debug "ALX"
}
if (siteFieldValue == "MLB")
{ 
security << ComponentAccessor.getUserManager().getUserByKey("user1b")
security << ComponentAccessor.getUserManager().getUserByKey("user2b")
ops << ComponentAccessor.getUserManager().getUserByKey("user3b")
log.debug "MLB"
}
if (siteFieldValue == "SATX")
{
security << ComponentAccessor.getUserManager().getUserByKey("user1c")
ops << ComponentAccessor.getUserManager().getUserByKey("user2c")
log.debug "SATX"
}
if (siteFieldValue == "Remote")
{
log.debug "Remote" 
}


security = security.unique()
securityField.updateValue(null, issue, new ModifiedValue(issue.getCustomFieldValue(securityField), security), new DefaultIssueChangeHolder())

ops = ops.unique()
opsField.updateValue(null, issue, new ModifiedValue(issue.getCustomFieldValue(opsField), ops), new DefaultIssueChangeHolder())

Hana Kučerová

Hi @Jeremy Cejka ,

please try something like this. There's some configuration, which needs to be set up. First of all - option ids for your site custom field. I've used ids instead of names, because it is more safer (ids don't change). Then also keys for your users. I didn't test it much and there are some cases, which should be also handled (like if site custom field is empty etc), but in general I believe it should work.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.ModifiedValue
import com.atlassian.jira.issue.customfields.option.Option
import com.atlassian.jira.issue.util.DefaultIssueChangeHolder
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import com.atlassian.jira.user.ApplicationUser
import com.atlassian.jira.user.util.UserManager

Long CUSTOM_FIELD_ID_SITE = 14203
Long CUSTOM_FIELD_ID_SECURITY = 14308
Long CUSTOM_FIELD_ID_OPS = 14303

Long CUSTOM_FIELD_SITE_OPTION_ID_ALX = 11111
Long CUSTOM_FIELD_SITE_OPTION_ID_MLB = 22222
Long CUSTOM_FIELD_SITE_OPTION_ID_SATX = 33333
Long CUSTOM_FIELD_SITE_OPTION_ID_REMOTE = 44444

String USER_KEY_1A = "JIRAUSER11111"
String USER_KEY_1B = "JIRAUSER22222"
String USER_KEY_1C = "JIRAUSER33333"
String USER_KEY_2A = "JIRAUSER44444"
String USER_KEY_2B = "JIRAUSER55555"
String USER_KEY_2C = "JIRAUSER66666"
String USER_KEY_3A = "JIRAUSER77777"
String USER_KEY_3B = "JIRAUSER88888"

CustomFieldManager customFieldManager = ComponentAccessor.getCustomFieldManager()
UserManager userManager = ComponentAccessor.getUserManager()

CustomField siteField = customFieldManager.getCustomFieldObject(CUSTOM_FIELD_ID_SITE)
CustomField securityField = customFieldManager.getCustomFieldObject(CUSTOM_FIELD_ID_SECURITY)
CustomField opsField = customFieldManager.getCustomFieldObject(CUSTOM_FIELD_ID_OPS)

Option siteFieldValue = issue.getCustomFieldValue(siteField) as Option
Long siteFieldOptionId = siteFieldValue.getOptionId()

List<ApplicationUser> securityUsers = []
List<ApplicationUser> opsUsers = []

switch (siteFieldOptionId) {
case CUSTOM_FIELD_SITE_OPTION_ID_ALX:
        securityUsers << userManager.getUserByKey(USER_KEY_1A)
        securityUsers << userManager.getUserByKey(USER_KEY_2A)
        opsUsers.add(userManager.getUserByKey(USER_KEY_3A))
break
    case CUSTOM_FIELD_SITE_OPTION_ID_MLB:
        securityUsers << userManager.getUserByKey(USER_KEY_1B)
        securityUsers << userManager.getUserByKey(USER_KEY_2B)
        opsUsers << userManager.getUserByKey(USER_KEY_3B)
break
    case CUSTOM_FIELD_SITE_OPTION_ID_SATX:
        securityUsers << userManager.getUserByKey(USER_KEY_1C)
        opsUsers << userManager.getUserByKey(USER_KEY_2C)
break
    case CUSTOM_FIELD_SITE_OPTION_ID_REMOTE:
// TODO ?
        break
}

if (securityUsers.size() > 0) {
    DefaultIssueChangeHolder changeHolder = new DefaultIssueChangeHolder()
    List<ApplicationUser> securityFieldValue = issue.getCustomFieldValue(securityField) as List<ApplicationUser>
    securityField.updateValue(null, issue, new ModifiedValue(securityFieldValue, securityUsers), changeHolder)
}

if (opsUsers.size() > 0) {
    DefaultIssueChangeHolder changeHolder = new DefaultIssueChangeHolder()
    List<ApplicationUser> opsFieldValue = issue.getCustomFieldValue(opsField) as List<ApplicationUser>
    opsField.updateValue(null, issue, new ModifiedValue(opsFieldValue, opsUsers), changeHolder)
}

Jeremy Cejka

@Hana Kučerová

Hypothetically, if I wanted to make this script more dynamic, instead of hardcoding users here in the script, use group members from ldap to populate my fields. I think I have enough to get started but need some help understanding arrays with a field being populated from a group with multiple members

Heres what I got so far in changing

Added

GroupManager groupManager = ComponentAccessor.getGroupManager()

In order to get the first iteration to fire (just to add members to multiuser picker) I had to change the following

def securityUsers = [] def opsUsers = [] switch (siteFieldOptionId) { case CUSTOM_FIELD_SITE_OPTION_ID_ALX: //opsUsers << userManager.getUserByKey(ALX_OP1) //securityUsers << userManager.getUserByName(ALX_SEC1) //securityUsers << userManager.getUserByName(ALX_SEC2) //securityUsers << userManager.getUserByName(SATX_SEC1) securityUsers = groupManager.getUsersInGroup(ALX_FSO) opsUsers = groupManager.getUsersInGroup(ALX_OPS) break

The group here has multiple users, but its a single line input, when I left the List securityUsers= [] the syntax checker threw and error for the variable definitions in the switch statement. So I changed it to def <variable> = [], (its not right. )

When I tried to add

 securityUsers << groupManager.getUsersInGroup(ALX_FSO) securityUsers << groupManager.getUsersInGroup(SATX_SEC1)

I got this

class java.util.ArrayList cannot be cast to class com.atlassian.jira.user.ApplicationUser

Ive got a work around,

securityUsers = groupManager.getUsersInGroup(ALX_FSO)

and that is for a single group I can add multiple users to securityUsers, I just cant do the array. So the work around would be to add users from the other group to the group that matches the site.

Thoughts?

Hana Kučerová

@Jeremy Cejka Plase try something like:

List<ApplicationUser> securityUsers = []
...
securityUsers.addAll(groupManager.getUsersInGroup(ALX_FSO))
securityUsers.addAll(groupManager.getUsersInGroup(ALX_FSO2))

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server