I want to be able to sort issues by the number of attachments

[Hazel Elgart]

How can I sort a list of issues by the number of attachments to per issue?

[Mehmet Kazgan · Accepted solution]

I think it is not possible to do that from JQL. Jamie Echlin's script runner has an issue function that can help, also you can create a custom field to query.

Here is some info here:

https://answers.atlassian.com/questions/150331/jql-query-to-get-issues-with-attachments

[Hazel Elgart]

Thanks Mehmet. I'd love a solution that non-admins could use.

How would the custom field work?

[Mehmet Kazgan]

Sure Hazel. Admin would create a field called "Number of Attachments" and update them manually accordingly. Then you can query on those. Unfortunately, there is not a way to automatically filter/order issues by the number of attachments OOTB.

[Hazel Elgart]

Thanks. I haven't done anything with SQL queries yet, but looks like I'll need to give it a try.