Search by attachment name

Hi

Is it possible in any way to be able to search attachment names, like for example "project = Testing AND attachmentname IN "Tech" "

I've noticed that it is not possible out of the box. Is that because Jira tracks attachment relations to issues in a separate table which is not search-indexed?

5 answers

1 accepted

Ok, just how I imagined it to be. Thanks for that link. I found this plug that, according to the comments, seem to work with Jira 4.4

https://plugins.atlassian.com/plugins/de.phil.jira.plugin

Glad you found out the plugin. I convert the comment to an answer, so if it works you can mark it.

Cheers.

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.

We have added UI support for Craftware JIRA Search Attachment.

Check out our guide on How to search attachments by filename or extension at https://akeles.jira.com/wiki/display/CANNED/How+to+search+attachments+by+filename+or+extension if you are interested.

Can anyone provide a useful answer that does not rely on plugins or administrative or SQL database access that most users simply will not have? 

Have u found any solution ?

0 vote
Thomas Schlegel Community Champion May 08, 2012
Hi, there is a plugin for that: https://plugins.atlassian.com/plugins/de.phil.jira.plugin Best regards Thomas

Hi,

It's not possible on JQL query, but I found this documentation that explains how to do it in a SQL query, not sure if that will be what you need.

Do you have Oracle query samples anywhere?

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,316 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot