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

Question

Hello everyone, so we use the following JQL queries to list story items... All Stories - project = '' ORDER BY Rank ASC Stories by Sprint - project = '' and Sprint = '' 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?

Vish Reddy {Revyz} · Answer

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

Hannes Obweger - JXL for Jira · Answer

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

Dennis Lubins · Answer

Thanks Jack, I kind of figured so.

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