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

Post Function - email latest attachment

timh77

I am looking to have a post-function that emails out the most recently attached PDF to the issue being transitioned. I have looked at the "Send custom email" post-function, but I can't think of how to send ONLY the most recent attachment that is a PDF.

I don't want to send all of the PDF attachments, only the latest one attached to the issue.

I am working with the assumptions that the attachments won't be added on this transition and that more than one of the specified type will be on the issue.

Does anyone have any insights into a custom attachment callback for this?

Accepted answers

Ram Kumar Aravindakshan _Adaptavist_

Hi @timh77 ,

You will need to use ScriptRunner's Send a custom email option in the Post-Function for your requirement.

And in the Send a custom email configuration, you will need to include some conditions in the Custom attachment callback field to customise your attachment requirement.

You can follow the steps below:-

In this example, the post function is added for the In Progress transition.

1) First, go to the Post Functions and add select the Add post function option as shown in the image below:-

2) Second, select the Send a custom email [ScriptRunner] option as shown in the image below:-

3) Once you are on the Send a custom email configuration page, configure the fields you need to, and mainly, for the Include Attachments section, select the Custom option.

Next, for the Custom attachment callback section, you can try out this working sample code:-

import com.onresolve.scriptrunner.canned.jira.workflow.postfunctions.mail.MailAttachment

{
    MailAttachment a ->

def issue = a.issue

def allAttachments = issue.attachments

def latest = allAttachments.findAll {

            it.filename.endsWith(".pdf")

        }.sort { it.created }.last()

        return latest.id == a.id
}

Please note, this sample code is not 100% exact to your environment. Hence you will need to make the required modifications.

What the code does, is that it reads through all the attachments in the issue and includes only the PDF files.

Once the PDF files are included in the list, the files are sorted according to the date of creation.

Finally, it selects only the latest PDF file in the list and adds it to the mail as an attachment.

Below is a print screen of the Send a custom email configuration:-

Lastly, save the post-function and publish the changes and try to transition your issue.

I hope this helps to solve your question.

Thank you and Kind Regards,

Ram

All comments

Ram Kumar Aravindakshan _Adaptavist_

Hi @timh77 ,

You will need to use ScriptRunner's Send a custom email option in the Post-Function for your requirement.

And in the Send a custom email configuration, you will need to include some conditions in the Custom attachment callback field to customise your attachment requirement.

You can follow the steps below:-

In this example, the post function is added for the In Progress transition.

1) First, go to the Post Functions and add select the Add post function option as shown in the image below:-

2) Second, select the Send a custom email [ScriptRunner] option as shown in the image below:-

3) Once you are on the Send a custom email configuration page, configure the fields you need to, and mainly, for the Include Attachments section, select the Custom option.

Next, for the Custom attachment callback section, you can try out this working sample code:-

import com.onresolve.scriptrunner.canned.jira.workflow.postfunctions.mail.MailAttachment

{
    MailAttachment a ->

def issue = a.issue

def allAttachments = issue.attachments

def latest = allAttachments.findAll {

            it.filename.endsWith(".pdf")

        }.sort { it.created }.last()

        return latest.id == a.id
}

Please note, this sample code is not 100% exact to your environment. Hence you will need to make the required modifications.

What the code does, is that it reads through all the attachments in the issue and includes only the PDF files.

Once the PDF files are included in the list, the files are sorted according to the date of creation.

Finally, it selects only the latest PDF file in the list and adds it to the mail as an attachment.

Below is a print screen of the Send a custom email configuration:-

Lastly, save the post-function and publish the changes and try to transition your issue.

I hope this helps to solve your question.

Thank you and Kind Regards,

Ram

timh77

That answers the question exactly as needed. The only other thing that I am having an issue with is defining the "Condition and Configuration". I have the below setup but keep getting this error:

groovy.lang.MissingMethodException: No signature of method: org.codehaus.groovy.jsr223.GroovyScriptEngineImpl.getCustomFieldObjectByName() is applicable for argument types: (String) values: [Client(s)]
at Script14.run(Script14.groovy:7)

Here is the current config section:

import com.atlassian.gzipfilter.org.apache.commons.lang.StringUtils
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.CustomFieldManager
 
// define custom fields to use
def customFieldManager = ComponentAccessor.getComponent(CustomFieldManager)
def clientsCf = getCustomFieldObjectByName('Client(s)') <-- Select list
def invoiceDateCf = getCustomFieldObjectByName('Invoice Date') <-- Date picker
def salesLeadCf = getCustomFieldObjectByName('Sales Lead') <-- User picker

// add value of custom fields to config map
config.clients = issue.getCustomFieldValue(clientsCf)
config.invoicedate = issue.getCustomFieldValue(invoiceDateCf)
config.salesLead = issue.getCustomFieldValue(salesLeadCf)

return true

Any suggestions?

Ram Kumar Aravindakshan _Adaptavist_

Hi @timh77

Great to hear that the solution worked for you.

After reviewing your Current Config Section code, it doesn't appear to be correct.

Firstly, you need to be aware that there are few Bound variables for the Current Config Section field. You do not need to initialise these variables. For example, the customFieldManager is a bound variable.

To find out the bound variables, you can click on the question mark symbol at the bottom right of the Condition and Configuration field as shown in the image below:-

When you click on the question mark, a dialog box will appear showing all the bound variables as shown in the image below:-

If you notice the image above, the customFieldManager is available amongst the list of Bound variables.

The second thing to take note of is that in your code, you do not appear to have any object reference to invoke the getCustomFieldObjectByName i.e.

def clientsCf = getCustomFieldObjectByName('Client(s)')
def invoiceDateCf = getCustomFieldObjectByName('Invoice Date')
def salesLeadCf = getCustomFieldObjectByName('Sales Lead')

This will not work. Instead, it would be best if you tried something like this:-

def clientsCf = customFieldManager.getCustomFieldObjectsByName('Client(s)')[0]
def invoiceDateCf = customFieldManager.getCustomFieldObjectsByName('Invoice Date')[0]
def salesLeadCf = customFieldManager.getCustomFieldObjectsByName('Sales Lead')[0]

Below is a full sample Condition and Configuration code for your reference:-

def clientsCf = customFieldManager.getCustomFieldObjectsByName('Client(s)')[0]
def invoiceDateCf = customFieldManager.getCustomFieldObjectsByName('Invoice Date')[0]
def salesLeadCf = customFieldManager.getCustomFieldObjectsByName('Sales Lead')[0]

config.clients = issue.getCustomFieldValue(clientsCf)
config.invoicedate = issue.getCustomFieldValue(invoiceDateCf)
config.salesLead = issue.getCustomFieldValue(salesLeadCf)

I hope this helps to solve your question

Thank you and Kind regards,

Ram

timh77

That got me what I needed. Thank you very much.

Hemanth Kumar_gphrv1

@Ram Kumar Aravindakshan _Adaptavist_ :

thanks for the approach, it worked for me. I need to figure out a way if we can filter/sort all PDF, Docx and Jpg file ? I need to get latest attachment irrespective of file format. I mean any of these three file format fetch me the latest.

I have tried ".pdf" && ".jpg" && ".docx" but it didn't work.

I need to sort attachments and fetch the latest one irrespective of file format

import com.onresolve.scriptrunner.canned.jira.workflow.postfunctions.mail.MailAttachment

{

MailAttachment a ->

def issue = a.issue

def allAttachments = issue.attachments

def latest = allAttachments.findAll {

it.filename.endsWith(".docx")

it.filename.endsWith(".pdf")

it.filename.endsWith(".jpg")

it.filename.endsWith(".png")

}.sort { it.created }.last()

return latest.id == a.id

}

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