Attachment size custom field JIRA

[Deleted user]

Hi everyone

We have a considerable amount of large files in our JIRA instance. From 100mb to 1gb.

I wanted to do a query for issues with attachments larger than 100mb, so we can make sure we have the file on our local archive, before deleting it.

We have ScriptRunner installed, so I tried modifying this script to return attachmentSize instead of numbers of attachments, but I can't get it to work.

import com.atlassian.jira.component.ComponentAccessor

def attachmentManager = ComponentAccessor.getAttachmentManager()
def numberAttachments = attachmentManager.getAttachments(issue).size()

// use the following instead for number of PDFs
//def numberAttachments = attachmentManager.getAttachments(issue).findAll {a ->
// a.filename.toLowerCase().endsWith(".pdf")
//}.size()

return numberAttachments ? numberAttachments as Double : null

Does anyone have a suggestion as to how I modify this script? Or another way to get a list of issues with large attachments? (We are running JIRA 6.4)

Thanks for your help,

/Nikolaj

[Nic Brough -Adaptavist- · Accepted solution]

I don't think REST exposes that information, because it's not a simple direct relationship.

Given a project, you'd need to read the list of people and groups in roles, then expand the groups out to people, then read the permission scheme to work out if your user matches the rules for access. You also need to think about what "access" means (just "I can see issue", or something else?), and how to handle the dynamic roles like assignee and reporter etc.

However, REST respects the permissions of the users internally, so if your rule is "person must have browse rights", then your normal user trying to use REST will only see the projects that they see when they use the UI.