Use the output of JQL in Additional Script in Scriptrunner

[Lars Swart]

Hi,

I use the Scriptrunner Escalation Service to monitor 5 projects for overdue issues.

Then an email should be send to all projectrole members of "QMB" of the project, the issue occurs from. 

I have the code to that for one specific project. Within this I use the projectkey to get the users and their mail adresses. 

In my mind there needs to be a way for the script to look up the JQL results and only get the users of the QMB-projectrole for this exact issue.

Does anybody had a problem like this before?

My code

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.jira.user.ApplicationUser
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("QMB")
def project = ComponentAccessor.getProjectManager().getProjectObjByKey("TA") 
def usersInRole = projectRoleManager.getProjectRoleActors(projectRole, project).getApplicationUsers()*.emailAddress.join(",")

// Create an email
def emailAddr = usersInRole 
def subject = "[Audit]: Measure overdue"
def body = "Hello dear QMB,\nan action is overdue.\nPlease speak to the assignee.\n\nJIRA issue: https://xxx.com/browse/${issue.key} - ${issue.summary}.\n\nBest regards,\nAuditprocess-Workflow\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)

Lars

[Lars Swart · Accepted solution]

I found a solution.

I get the projectID directly from the issues that comes out of the JQL Query. 

// Get all the mail addresses from the role members of the project of the issue
def projectRoleManager = ComponentAccessor.getComponent(ProjectRoleManager)
def projectRole = projectRoleManager.getProjectRole("QMB")
def project = issue.getProjectObject()
def usersInRole = projectRoleManager.getProjectRoleActors(projectRole, project).getApplicationUsers()*.emailAddress.join(",")

So for all that are interested. Here is the complete code

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.jira.user.ApplicationUser
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 the project of the issue
def projectRoleManager = ComponentAccessor.getComponent(ProjectRoleManager)
def projectRole = projectRoleManager.getProjectRole("QMB")
def project = issue.getProjectObject()
def usersInRole = projectRoleManager.getProjectRoleActors(projectRole, project).getApplicationUsers()*.emailAddress.join(",")

// Create an email
def emailAddr = usersInRole 
def subject = "[Audit]: Measure overdue"
def body = "Hello dear QMB,\nan action is overdue.\nPlease speak to the assignee.\n\nJIRA issue: https://xxx.com/browse/${issue.key} - ${issue.summary}.\n\nBest regards,\nAuditprocess-Workflow\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)

[Radek Dostál]

This looks fine on first look (but the emailAddress csv text might contain ", null" in case one of role actors has no email. The body will I think show up with "\n" in it because it should be sent as plain text I think.

Could you add more logging such as 'log.warn("Sending email to: " + emailAddr)' so we can trace how far and what values the script contains?

There also was a problem at one point with classpath and openjdk - but you should be able to see an exception in atlassian-jira.log that it wasn't able to find class by name or something like that.

I would add a few more log lines and then check atlassian-jira.log to see what's going on.

[Lars Swart]

Hi Radek, I added the log.warn line to the code.

Here ist what the log file comes up with.

2022-02-24 16:09:46,963+0100 http-nio-8080-exec-20873 WARN admin_lokal 969x773824x1 oa312a 192.168.x.x:3676,0:0:0:0:0:0:0:1 /rest/scriptrunner/latest/scheduled-jobs/com.onresolve.scriptrunner.canned.jira.jobs.EscalationService/preview [c.o.scriptrunner.runner.ScriptBindingsManager] Sending email to: user.name@company.de,lars.brozinski@company.de

So everything is fine. Btw. we only have users with email adresses in these roles. So ne "null" problematic shouldnt be a problem.

But how does this brings us forward in my original problem?