In JQL, is there a way to filter attachments by file size

[Dennis Lubins]

Hello everyone, so we use the following JQL queries to list story items...

All Stories - project = '<storyboard>' ORDER BY Rank ASC

Stories by Sprint - project = '<storyboard>' and Sprint = '<sprintID>' ORDER BY Rank ASC

The above queries work fine, they pull all the proper information. What we are looking to do is run the queries above but omit (but not to delete them) any attachments larger than say 50 megs from the resulting report.

Is there a way to accomplish this?

[Hannes Obweger - JXL for Jira]

Hi @Dennis Lubins

if you're open to solutions from the Atlassian Marketplace, you may wanna have a look into the app that my team is working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you'd do in e.g. Excel or Google Sheets. It also comes with a number of so-called "smart fields" that aren't natively available, including the attachments size. This field shows the total size of all attachments on the given issue, rather than the sizes of individual attachments. Depending on your exact setup and use case, this may or may not do the trick 🤞

This is how this looks in action:

Once you've narrowed down your list of issues, you can edit these issues directly in JXL, trigger various actions in Jira, or export them for further processing.

Any questions just let me know,

Best,

Hannes

[Jack Brickey]

jql does not support attachment file size. there may be something in the marketplace but I am not aware of any personally.

[Dennis Lubins]

Thanks Jack, I kind of figured so.

Oh well, never hurts to ask though. Thanks for the help.

[Vish Reddy {Revyz}]

Hi @Dennis Lubins 

I don't believe there is a way to get the attachments only with JQL. Having said that, you could try our Revyz Backup & Restore app and provide you with analytics on attachments, including which Jira issues have attachments and your can filter them based on size etc..

Given that we backup your Jira data, we know exactly how many attachments exists and which Jira issues they are attached to etc.., we are building more capabilities, would love to hear your use case if you are open to a conversation.

Thank you

Vish