Search by attachment name from JQL

[sm.park]

Hi.

I created a custom field that uses a scriptrunner to display the attachment name. I would like to search for issues with only attachments, but JQL shows incorrect search results. Can you help me figure out which code is wrong?

import com.atlassian.jira.component.ComponentAccessor

def attachments = ComponentAccessor.getAttachmentManager().getAttachments(issue)
def Result = null

Result = attachments.collect {
it.filename

}.join(", ")

return Result

[Leonard Chew · Accepted solution]

I have created a scripted field called "AttachmentName" with your script, and it seems to be OK.

In which way does your system not work correctly? - Have you run a full reindex?

[Leonard Chew]

Ah, I have found the flaw.

Your script always sets a value, even if the attachments are empty, so when you query with "AttachmentName is empty", it will not return any records.

Change your code like this:

import com.atlassian.jira.component.ComponentAccessor

def attachments = ComponentAccessor.getAttachmentManager().getAttachments(issue)
def Result = null

if (!attachments.empty)
{
Result = attachments.collect {
it.filename
}.join(", ")
}

return Result

-> leave your result null, if there are no attachments, then you can also query on "is empty"

[Leonard Chew]

Apart from your own scripted field, Scriptrunner provides functions to query for attachments, such as

issueFunction in hasAttachments ("docx")

Maybe you dont even need a scripted field

[sm.park]

Thank you for your helpful.

[jamila.augustine]

@Leonard Chew : Thanks from another beneficiary!