Search and show all tickets, that have attachments

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

5 answers

1 accepted

1 vote
Thomas Schlegel Community Champion May 29, 2012

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

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

8 votes
Andrew Lui Atlassian Team Mar 09, 2014

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

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

{code}

project = "projectName" AND NOT attachments is EMPTY

{code}

Great, thank you!

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

1 vote

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

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

Yeah, but I guess it is worth the cost.

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.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Sunday in Agility

You asked for it, so we delivered: images on issues have arrived

A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...

300 views 3 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you