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

Change the custom field values with attached attachment name

jira_admin_cu

Hi Team,

Is this possible? If an attachment is attached with a certain text in the attachment name update a custom text field with the attachment name?

Example: if a change request gets an attachment called peerQCxyz.xls, look for "peerQC" and set the value of a text field to peerQCxyz. If there is peerQCyz.xsl after have initial value set, that initial value can be overwritten and have the text field value peerQCyz.

Is this feasible?

Accepted answers

Ram Kumar Aravindakshan _Adaptavist_

Hi @jira_admin_cu

For your requirement, I recommend using ScriptRunner's Listener.

You must use ScriptRunner's Custom Listener and the IssueUpdated event, triggering whenever an Attachment is added to the issue.

Below is a sample working code for your reference:-

def issue = event.issue

//Update the Field Name 
def fieldName = 'Sample Text Field'

issue.update {

if (issue.attachments.size() > 0) {
    def fileName = issue.attachments.last().filename
    def attachmentFileName = fileName.substring(0, fileName.indexOf('.'))
    setCustomFieldValue(fieldName, attachmentFileName)
 } else {
     setCustomFieldValue(fieldName, '')
 }
}

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

Below is a screenshot of the Listener Configuration:-

Below are a couple of test screenshots for your reference:-

1. First, I created a sample Issue.

2. Next, I am adding an attachment to it.

3. Once the Attachment is added, as expected, the Sample Text Field is updated with the attachment's file name.

4. Next, I tried to add another attachment, and as expected, the Sample Text Field is also updated as expected.

Note: once you have added the attachment, please ensure to refresh your browser to see the update take place.

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram

All comments

Mohanraj Thangamuthu

Hello, Good day. You can try the automation rule to check the file name and edit the custom field.

Screenshot 2023-08-15 at 10.41.15 AM.png

Ram Kumar Aravindakshan _Adaptavist_

Hi @jira_admin_cu

For your requirement, I recommend using ScriptRunner's Listener.

You must use ScriptRunner's Custom Listener and the IssueUpdated event, triggering whenever an Attachment is added to the issue.

Below is a sample working code for your reference:-

def issue = event.issue

//Update the Field Name 
def fieldName = 'Sample Text Field'

issue.update {

if (issue.attachments.size() > 0) {
    def fileName = issue.attachments.last().filename
    def attachmentFileName = fileName.substring(0, fileName.indexOf('.'))
    setCustomFieldValue(fieldName, attachmentFileName)
 } else {
     setCustomFieldValue(fieldName, '')
 }
}

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

Below is a screenshot of the Listener Configuration:-

Below are a couple of test screenshots for your reference:-

1. First, I created a sample Issue.

2. Next, I am adding an attachment to it.

3. Once the Attachment is added, as expected, the Sample Text Field is updated with the attachment's file name.

4. Next, I tried to add another attachment, and as expected, the Sample Text Field is also updated as expected.

Note: once you have added the attachment, please ensure to refresh your browser to see the update take place.

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram

Reshma Begum {Appfire}

Hi @jira_admin_cu ,

Using JMWE's Event Based Actions you can add the Event-based action

1. Select the Event: Issue Field Value Changed
2. Select Attachment under the Fields to monitor section

Under Post Functions, add the Set Issue Fields Post Function and select the text field that you want to update and add the below script:

if (!!issue.get("attachment"))
issue.get("attachment")?.first()?.filename.takeBefore(".")

When an attachment is added, you will see the value being updated with the file name without the extension.

If there is more than one attachment, the script takes the first attachment into consideration.

Hope this helps!

Thanks,

Reshma

jira_admin_cu

Thank you so much Ram! @Ram Kumar Aravindakshan _Adaptavist_ , its working, but the actual requirement is :

Not blindly override but it if matches a naming convention.

Let's say I want to check for a specific attachment type and I asked folks to make attachments of that type starting with Peer........pdf, only then get the attachment name and place it in the field.

if attachment starts with QC......xsl then don't write it over to that field.

btw extension of these files don't matter. Only that a subtext is part of the attachment name

jira_admin_cu

Thank you so much @Reshma Begum {Appfire} _ , its working, but the actual requirement is :
Not blindly override but it if matches a naming convention.

Let's say I want to check for a specific attachment type and I asked folks to make attachments of that type starting with Peer........pdf, only then get the attachment name and place it in the field.

if attachment starts with QC......xsl then don't write it over to that field.

btw extension of these files don't matter. Only that a subtext is part of the attachment name

Sriram Kancharla

Hello, I have extended @Ram Kumar Aravindakshan _Adaptavist_'s solution to check for the regex.



def issue = event.issue

//Update the Field Name 
def fieldName = 'Sample Text Field'

Set re = New RegExp
With re
.Pattern = "^peer[\d\w]+\.pdf$"
.IgnoreCase = True
.Global = False
End With

issue.update {
if (issue.attachments.size() > 0) {
foreach(attachment in issue.attachments)
{
fileName = issue.attachments.last().filename
if(re.Test(fieldName))
{
def attachmentFileName = fileName.substring(0, fileName.indexOf('.'))
setCustomFieldValue(fieldName, attachmentFileName)
}
} 
} else {
setCustomFieldValue(fieldName, '')
}
}

Reshma Begum {Appfire}

Hi @jira_admin_cu ,

Thank you for giving it a try!

To check for a specific attachment name, modify the script as shown below

if (!!issue.get("attachment") && 
issue.get("attachment")?.last()?.filename.startsWith("peer") == true)

issue.get("attachment")?.last()?.filename.takeBefore(".")

Please let us know if this meets your requirement.

Thanks,

Reshma

Ram Kumar Aravindakshan _Adaptavist_

Hi @Sriram Kancharla / @jira_admin_cu

A simpler approach instead of adding a Regex, would be to just add another if condition as shown below:-

def issue = event.issue

//Update the Field Name 
def fieldName = 'Sample Text Field'

issue.update {

if (issue.attachments.size() > 0) {
    def fileName = issue.attachments.last().filename

    //To filter the filename
    if (fileName.toLowerCase().startsWith('peer')) {
 def attachmentFileName = fileName.substring(0, fileName.indexOf('.'))
 setCustomFieldValue(fieldName, attachmentFileName)
 }
 } else {
 setCustomFieldValue(fieldName, '')
 }

I hope this helps to solve your question. :-)

Thank you and Kind regards,
Ram

jira_admin_cu

Hi @Reshma Begum {Appfire} ,

I tried it using JMWE.

I attached peer1, peer2, peer3, etc.; the field value also changed accordingly.

But, I deleted Peer1 from the ticket and attached it again, but the existing value didn't update to Peer1; it's still the same old value.

And if I attach the file with and upper case letter file like "Peer" or "Peer1", it doesn't work again.

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

addon-com.innovalog.jmwe.jira-misc-workflow-extensions