Search and show all tickets, that have attachments

[skorzinetzki]

Hello,

I'm facing a problem. Is it possible to define an advanced search, that shows me all tickets in a given project, which have attachments?

Something like:

project = "projectName" AND attachments IS NOT EMPTY

There is no field "attachments"...

Thank you in advance!

Steve

[Thomas Schlegel · Accepted solution]

Hi Steve,

this does not work out of the box. You have to use the JQL Tricks Plugin (https://marketplace.atlassian.com/31399) . Unfortunately it is not free.

Best regards

Thomas

[skorzinetzki]

Thank you for your fast response. This answer fits my needs! :)

[Xander Vikunas]

this can be done natively without JQL Tricks (although that plugin is pretty awesome)

{code}

project = "projectName" AND NOT attachments is EMPTY

{code}

[Martin Böhme]

Great, thank you!

This answer should be the one that is marked as solved...

[Gotham Mehra]

I concur. This works perfectly. You can't see the name of the attachment, but you can filter for any type of issue that has an attachment.

[Daniel Gomez]

this worked for me. filtered all issues with attachments in that project

[Reena Elizabeth]

Great Xander. I m able to see all the stories with attachments.

[Chibuzor Nwobi]

This is very helpful. Worked for me. Thank you.

[Ric Palmer]

Perfect, simple, easy. I also used it to see all sub-tasks for a parent that had attachments. 

[Yatish Madhav]

Thanks for the response here ... "attachments is not EMPTY" worked for me to get a filter of all issues with attachments on our Jira instance. Thanks

[Andrew]

You can now do this in JIRA 6.2 using the attachments JQL function.

[Piotr Bojko]

Check this add-on : https://marketplace.atlassian.com/plugins/pl.craftware.jira.search-attachments-plugin

It can do following queries:

• issue in havingAttachments()
• issue in havingAttachments("search text")
• issue in havingAttachments("type:pdf")
• issue in havingAttachments("name:workflow type:png")
• any mix of above

It can search across pdf, office docs (ms/open/libe) and so on - it uses extractors for this formats.

[Nic Brough -Adaptavist-]

I wrote a plugin to solve this with a derived field, ages ago. I really should dig it out and publish it.

[Erwin Manuel]

Hi Nic, were you able to publish the plugin? The JQL Tricks Plugin is not free.

[Renjith Pillai]

Yeah, but I guess it is worth the cost.