Insight - How to filter objects by attachments

[Ferenc Kis]

Hi,

We have a relatively big data for our Insight (3000+ objects and 50+ attributes) and I would like to create a filter that displays all objects those do not have any attachments.

usecase:
objects should have an attachment (usually contracts) and would be nice to have a filter to see if it is missing somewhere. Even better if we can search for an extension or name + extension.

As "attachments" feature is a built-in one for Insight it would be obvious to have such a filtering but I did not find any.

I've checked the IQL documentation and attachments are not mentioned:
https://support.atlassian.com/jira-service-management-cloud/docs/use-insight-query-language-iql/

Any idea how it can be filtered? Is it even possible?

[Jose Luis Gaitan]

Hello, @Ferenc Kis You can filter using the following:

attachments IS NOT EMPTY  

Try it and tell us the result :)

[Ferenc Kis]

Hi @Jose Luis Gaitan 

Yeah, I've tried a couple ways and did not work (IS, HAVING).
Tried the attachments.customer DOT feature.

Error

No matching attribute for IQL clause ("attachments" IS NOT EMPTY)

Seems the built-in attachment is not an attribute

[Jose Luis Gaitan]

Are you using it with quotes? You must use it without quotes.

You can use autocomplete to see which operators that you can use. Do you see more operators related with attachments? 

[Ferenc Kis]

In Insight the IQL is not working with autocomplete, unfortunately.
The same working logic on the server version (using both)

[Ferenc Kis]

maybe you are mixing it with JQL?