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

1 vote
Accepted answer

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.

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 ?

Hi Jurgen, my solution was to stop using Atlassian products.

For me and my clients buying yet another plug-in is just not a workable solution. This is Atlassian's answer for far too many fundamental issues that go unaddressed for years.

Can I ask what alternate solution do your organization selected over atlassian Jira?

We are having the same never ending problems in which there is no simple solution,

plus plugin instalation is not allowed in organization.

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.

0 votes
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 Sign up to answer
Community showcase
Published Wednesday in Jira

Make your Atlassian Cloud products more secure: our NEW admin security guide

Hey admins! I’m Dave, Principal Product Manager here at Atlassian working on our cloud platform and security products. Cloud security is a moving target. As you adopt more products, employees consta...

44 views 0 2
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