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; } } }

Scriptrunner Jobs: Get customfield value of currently found issues

Lars Swart

Hi,

I have a Scriptrunner job that runs every 24h. If the JQL Statement finds issues, for everyone of them an email should be send. That works fine for me.

But every issue has a customfield with a user stored within.

How can I get this username for the issue that the jql statement just found?

I got this code, but here I need to specify the issue myself.

import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.MutableIssue
import com.atlassian.jira.project.Project


def issueManager = ComponentAccessor.issueManager
def customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObject("customfield_11402")
def issue = issueManager.getIssueByCurrentKey("PER-289")
def value = (String) issue.getCustomFieldValue(customField)

log.warn(value)

And the second question is:

How do I get the email address from the user I just found in the customfield?

For project role users I used this very good working code. But the role stay the same over the whole project. So that was "easy".

// Get all the mail addresses from the role members of a project
def projectRoleManager = ComponentAccessor.getComponent(ProjectRoleManager)
def projectRole = projectRoleManager.getProjectRole("Sales")
def project = ComponentAccessor.getProjectManager().getProjectObjByKey("PER") 
def usersInRole = projectRoleManager.getProjectRoleActors(projectRole, project).getApplicationUsers()*.emailAddress.join(",")

Thanks for reading my stuff

Accepted answers

Martin Bayer _MoroSystems_ s_r_o__

Hi @Lars Swart I guess your job contains JQL? Or how do you collect the issues? I think you need

select issues using JQL
go through the issues selected by JQL
get user from custom field
get its email address

Am I correct? Can you share your job's script?

All comments

Martin Bayer _MoroSystems_ s_r_o__

Hi @Lars Swart I guess your job contains JQL? Or how do you collect the issues? I think you need

select issues using JQL
go through the issues selected by JQL
get user from custom field
get its email address

Am I correct? Can you share your job's script?

Lars Swart

Hi Martin,

Here is the JQL Statement which selects the issues

project = PER AND issuetype = Contract AND status = "7-18 months" AND "Real Startdate" <= -68w

And here the current code, which works fine. But I also want to inform the users from the customfield with this mail

import com.onresolve.scriptrunner.runner.rest.common.CustomEndpointDelegate
import groovy.transform.BaseScript
import com.atlassian.jira.issue.issuetype.IssueType
import javax.ws.rs.core.Response
import javax.ws.rs.core.MultivaluedMap
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.Issue
import com.atlassian.jira.issue.IssueManager
import com.atlassian.jira.issue.MutableIssue;
import com.atlassian.jira.event.type.EventDispatchOption
import com.atlassian.jira.issue.CustomFieldManager
import com.atlassian.jira.issue.fields.CustomField
import com.atlassian.jira.config.IssueTypeManager;
import com.atlassian.jira.issue.link.IssueLink
import com.atlassian.jira.security.roles.ProjectRoleManager
import com.atlassian.mail.Email
import com.atlassian.mail.server.MailServerManager
import com.atlassian.mail.server.SMTPMailServer
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletRequest;

// Get all the mail addresses from the role members of a project
def projectRoleManager = ComponentAccessor.getComponent(ProjectRoleManager)
def projectRole = projectRoleManager.getProjectRole("Sales")
def project = ComponentAccessor.getProjectManager().getProjectObjByKey("PER") 
def usersInRole = projectRoleManager.getProjectRoleActors(projectRole, project).getApplicationUsers()*.emailAddress.join(",")


// Create an email
def emailAddr = usersInRole
def subject = "It's been 17 months"
def body = "Hi, it's been 17 months since the start.\n\nAll Details can be found here:\n\nhttps://jira.xxx.de/browse/${issue.key} - ${issue.summary}. \n\n\"

def sendEmail(String emailAddr, String subject, String body) {
SMTPMailServer mailServer = ComponentAccessor.getMailServerManager().getDefaultSMTPMailServer();
if (mailServer) {
Email email = new Email(emailAddr);
email.setSubject(subject);
email.setBody(body);
mailServer.send(email);
} else {
// Problem getting the mail server from JIRA configuration, log this error
}
}

sendEmail (emailAddr, subject, body)

Martin Bayer _MoroSystems_ s_r_o__

Ok, I think following code is sufficient . I added few comments too..

def customField = ComponentAccessor.getCustomFieldManager().getCustomFieldObject("customfield_11402") // getting custom field of Single user picker
def user = issue.getCustomFieldValue(customField) // getting value of Single user picker field as ApplicationUser (https://docs.atlassian.com/software/jira/docs/api/7.1.0/com/atlassian/jira/user/ApplicationUser.html)
def userEmailAddr = user.getEmailAddress()

Lars Swart

Hi Martin

thank you for your kind support.

I added

import com.atlassian.jira.user.ApplicationUser

and your code to my job script. But I get an error.

I use JIRA 8.2.2. - the current documentation version for this version seems to be the same as the one you linked.

https://docs.atlassian.com/software/jira/docs/api/8.5.12/

So I think the name of the method is not the problem.

Have you a suggestion?

Martin Bayer _MoroSystems_ s_r_o__

Hi @Lars Swart it is only static check error. It occurs because you are not using Java "types" in groovy code. It should not be problem. You can save script with these errors and test it.

Welcome!

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

Quick Links

Find more posts tagged with

server

scriptrunner

jira-software

jira-software-server

groovy