JQL search for issues that have attachments

[Alexander Pappert]

Hi,

according to the fields reference, I should be able to perform the following JQL search in JIRA Server 7.8

• Search for issues that have attachments:
  attachments IS NOT EMPTY  

• Search for issues that do not have attachments:
  attachments IS EMPTY 

But I get the following error:

Field 'attachments' does not exist or you do not have permission to view it.

How can I search for attachments?

[Yogesh Mude]

HI @Alexander Pappert,

While seeing this error might be you don't have permission to View/Crete the attachment.

[Alexander Pappert]

I can create & delete Attachments in the Project.
I am Admin and I have the permissions.

I think it is the "Field 'attachments' does not exist". But why?

[Sherwin Soriano]

Is it possible to query tickets that have attachments of 5mb or larger?

[Alexander Pappert]

@Tarun Sapra

Atlassian Support found my Problem and the correponding JIRA Bug

My Attachment field was hidden in the field configuration scheme

https://jira.atlassian.com/browse/JRASERVER-62852

[Tarun Sapra]

Thanks @Alexander Pappert glad that it's now known to you as to why it wasn't working.

[Tarun Sapra]

Hello @Alexander Pappert

In the JQL did you mention the project as part of the JQL. Because if you just search -

attachments IS NOT EMPTY  

Then there can be some projects wherein you actually don't have permissions to access the attachements, thus try the same JQL but with the project criteria like

Project = ABC and attachments IS NOT EMPTY 

[Alexander Pappert]

Hi @Tarun Sapra

I use "Project = ABC and attachments IS NOT EMPTY"
While typing this in JQL, I cannot type the complete word "attachment". JQL stopps at "at" because "attachment" is maybe an invalid word.

In Project ABC, I have uploaded some attachments & the rights in the project permission scheme to add and delete attachments. So the JQL should work.

Is there some extra Point I have to activate in the Settings?

[Tarun Sapra]

Hello @Alexander Pappert

Which version of JIRA are you using? 

[Alexander Pappert]

@Tarun Sapra
I use JIRA Server 7.8.2, as posted above: "according to the fields reference, I should be able to perform the following JQL search in JIRA Server 7.8"

[Tarun Sapra]

Ah, yes indeed, my bad I read too fast and skipped this detail.

[Tarun Sapra]

It's a bit surprising that a builtin functionality is not working despite you having the permissions. Is it not working for any other projects as well?

[Alexander Pappert]

I have attachments in 3 Projects. All 3 are not working.

So, in your jira it is working?

[Tarun Sapra]

Yes, it's working for me. I have JIRA 7.7

[Alexander Pappert]

Server or Cloud?

[Tarun Sapra]

Server version, as 7.x means server, cloud is always the latest build 100.x or something.