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

Query issues with attachment sorted by size is that possible??

Bernardo San Ju3

Dear Answers community,

We need to archive a whole lot of attachments load. We are hitting storage limit and want to start solving this issue. We will archive some issues and projects but I would also want to have a good criteria to search for issue with a lot of load.

For that I used JQL: "attachments is not empty"

But I can not know what is the size of the attachment. Any suggestion on how to solve this case? I want to have a list of issues with attachments, this list should included attachment size.

Cheers

Accepted answers

Nic Brough -Adaptavist-

You will definitely need some code to enable this - something that can go into an issue, check the attachments and display the size.

Francis is right in that the Script Runner could give you a scripted field that could display the total size of all attachments on an issue, and it's only a few lines of code.

But there's no Script Runner on Cloud, and the restrictions mean that you can't add similar add-ons either.

But, two other options

Write a Connect add-on that can fetch the attachment sizes
Do it externally - run your filter over REST and iterate through the results, pulling the attachment meta-data down over REST.

Both of those would use https://docs.atlassian.com/jira/REST/latest/#api/2/attachment-getAttachment

All comments

francis

Did you consider a scripted field (script runner) which is set with the total size of all attachments related to an issue ?

Bernardo San Ju3

Hi Francis,

No, did not consider that. I want to know if there is other approaches rather than recurring to scripts. However, thks for your quick reply, I may give it a try if no other option.

Nic Brough -Adaptavist-

You will definitely need some code to enable this - something that can go into an issue, check the attachments and display the size.

Francis is right in that the Script Runner could give you a scripted field that could display the total size of all attachments on an issue, and it's only a few lines of code.

But there's no Script Runner on Cloud, and the restrictions mean that you can't add similar add-ons either.

But, two other options

Write a Connect add-on that can fetch the attachment sizes
Do it externally - run your filter over REST and iterate through the results, pulling the attachment meta-data down over REST.

Both of those would use https://docs.atlassian.com/jira/REST/latest/#api/2/attachment-getAttachment

Bernardo San Ju3

Many thks to both. Ill go for that

Contact Kintosoft

SQL for JIRA is also an option as the ISSUEATTACHMENTS table supports FILESIZE

Bob Swift

The following action from JIRA Command Line Interface (CLI) will give you a CSV file of issues and attachments with size:

--action runFromIssueList --jql "project = XXX" --common "--action getAttachmentList --issue @issue@ --file attachmentList.csv --append --outputFormat 2" --clearFileBeforeAppend

unknown

Hi Francis,

I am looking for exactly a script like that, but I can't get it to work. How would you write it?

unknown

Hi Nic

Sorry for reviving old threads, but you always seem to be able to help me in here smile

I could really use a script (for ScriptRunner), that can tell me the attachment size per Issue. I managed to find one that gives me number of attachments, but that doesnt really help me unfortunately.

Hopefully you'll see this,

Best regards Nikolaj

Nic Brough -Adaptavist-

Tibor beat me to it with https://answers.atlassian.com/questions/44223581

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jira-core