It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Answer accepted
Thomas Schlegel Community Leader 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! :)

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...

Like iwayq Technology likes this

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.

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

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

Like Safari Support likes this

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

9 votes
Andrew Lui Atlassian Team Mar 09, 2014

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

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
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

867 views 6 24
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you