Send custom email Using ScriptRunner based on Filter Condition results

[Nagappan Murugappan]

Hello

I am completely new to JIRA administration, we are using script runner to schedule different jobs, and one of the requirement is, based on the certain filter condition results, a job needs to be scheduled on certain time frame to send email with the customized body, JIRA ticket number etc,. 

What i have tested so far is just simple email sending code which is as follows..

import com.atlassian.mail.Email
import com.atlassian.mail.server.SMTPMailServer
import com.atlassian.jira.component.ComponentAccessor

def emailSubject = "JIRA CHECK"
def emailBody = "Test CHECK"
def emailAddress = "<emaild id>"

SMTPMailServer mailServer = ComponentAccessor.getMailServerManager().getDefaultSMTPMailServer()

if (mailServer) {
Email email = new Email(emailAddress)
email.setSubject(emailSubject)
email.setBody(emailBody)
mailServer.send(email)
} else {}

[Nagappan Murugappan · Accepted solution]

Hello Helmy

Sorry about the late reply, i would try your option and let you know whether it helps. 

I already have an flter_id eg 123, i want to see whether 123 returns me any result, if yes, then with the content of the Customized email message, i want to send to the respective recipients.

Thank You.

[Boris Berenberg - Atlas Authority]

Hi Nagappan,

We don't yet support customized bodies, but we support everything else you said out of the box with Notification Assistant for Jira (a Staff Pick).  And we have customized notification templates coming in the next month! 

[Helmy Ibrahim _Adaptavist_]

Hi Nagppan,

Thank you for using ScriptRunner.

Can you clarify what you meant by "Filter Condition"? Providing examples would help too!

As for the scheduled script, you could use Script Jobs by ScriptRunner. It accepts cron expression to define the interval a job is run at.

[Nagappan Murugappan]

Hi Helmy

For example 

issuetype = Issue AND status in ("In Progress", Open) and created < -10w

I want to scan the results from the above filer (have saved the filter too and have the filter id with me), and if the filter returns any result, then would like to sent Email to certain email id.

[Helmy Ibrahim _Adaptavist_]

Hi Nagppan,

You can execute a JQL query in your code and then do a simple checking:

if (search.results) {
    // send email
}

I hope this helps!

[Nagappan Murugappan]

Hello Helmy

Thanks for the link, it really helped and i was able to send the custom email.