I am looking for scriptrunner code to add the multi select fields value in a custom email

Question

I have created a custom email post function to send an email to approvers for approving an access. This access field is a multiselect field in JIRA. How to add the script to display multi-select field value on email. Here is my email code that works fine import com.atlassian.jira.mail.Email import com.atlassian.jira.component.ComponentAccessor import com.atlassian.jira.security.groups.GroupManager import com.atlassian.jira.ComponentManager def groupManager = ComponentAccessor.getComponent(GroupManager.class) def groupUsers = groupManager.getUsersInGroup("NPPMO-PRV-APPROVAL-GROUP") def baseurl = ComponentAccessor.getApplicationProperties().getString("jira.baseurl") //Email body template def body=" Hello,

Privilege Access Approvers,

Please note that a new member account request has been created and Privielege Access is requested. Please log in to JIRA to review the details and click on Approve or Reject transition accordingly" body+="

The link for Ticket details in Jira is provided below.

Thanks.

" body+="--------------------------------------------------------
" body+="
$issue.key
" body+="--------------------------------------------------------
" body+="
Summary: ${issue.summary}" body+="
Issue Key: ${issue.key}" body+="
URL: ${baseurl}/browse/$issue.key" //body+="
Project:$issue.project.name" body+="
Issue Type: $issue.issueType.name" body+="
Reporter: $issue.reporter.displayName" body+="
Assignee: $issue.assignee.displayName" //body+="
PrivilegeAccess: $issue.privilegeaccess.displayName" body+="
--------------------------------------------------------
" //Email subject def subject="($issue.key) ${issue.summary} | Your Approval Required for Privilege Access" //def thetext = "" groupUsers.each() { // thetext += it.getDisplayName() + it.getEmailAddress()+ "(" + it.getName() + ")
" sendEmail(it.getEmailAddress(), subject, body) } // send email def sendEmail(String emailAddr, String subject, String body) { def mailServer = ComponentAccessor.getMailServerManager().getDefaultSMTPMailServer() if (mailServer) { Email email = new Email("temporary@example.com") email.setTo(emailAddr) //email.setReplyTo("dojosupport@publicis.sapient.com") // email.setFrom("dojosupport@publicis.sapient.com") //log.error "Email address:" + emailAddr email.setSubject(subject) //log.error "Subject: " + subject email.setBody(body) //log.error "Body: " + body email.setMimeType("text/html") mailServer.send(email) //log.error("Mail sent") } else { log.error("Please make sure that a valid mailServer is configured") } } //return thetext ------------------- Just want to display the multiselect field value to show the tool list that needs access approval

PD Sheehan · Accepted Answer

To get custom field value you must * first, get a custom field object * then get the value from the issue (array of "options) * then collect the value from those options * and finally, join the elements in the array for the email body def customFieldManager = ComponentAccessor.customFieldManager def multiSelectField = customFieldManager.getCustomFieldObjectByName("name of your multi select") //def multiSelectField = customFieldManager.getCustomfFieldObject(123456) //id of the custom field customFieldValues = issue.getCustomFieldValue(multiSelectField).collect{it.value}.join("
" Also, did you know that you can do this in groovy? Makes the code/email body much easier to read and visualize the final format. def body=""" Hello, Privilege Access Approvers, Please note that a new member account request has been created and Privielege Access is requested. Please log in to JIRA to review the details and click on Approve or Reject transition accordingly The link for Ticket details in Jira is provided below. Thanks. -------------------------------------------------------- $issue.key -------------------------------------------------------- Summary: ${issue.summary} Issue Key: ${issue.key} URL: ${baseurl}/browse/$issue.key Issue Type: $issue.issueType.name Reporter: $issue.reporter.displayName Assignee: $issue.assignee.displayName -------------------------------------------------------- """.stripIndent().replaceAll(" ","
")