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

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

Accepted answers

Lars Swart

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)

All comments

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?

Lars Swart

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)

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

jira-server

job

escalation