JQL for cases that contains attachments with a specific name?

[Abdelrahman R]

Dear all community members,

I hope you are well today,

I would really appreciate your support to provide the JQL syntax that would retrieve all cases that contain attachments with a specific name if applicable.

Thanks in advance.

[Marlene Kegel - codefortynine]

Hello @Abdelrahman R

I am Marlene from codefortynine.

With Dynamic Custom Fields for Jira you can create a computed custom field which contains the names of the attached files. The field gets automatically updated, when an attachment was added or removed.

Once you've added the field to your issues, you can easily filter for issues which contains attachments with a specific name.

 

The field is created with Jira expressions, but since we offer a template for your use case, you don't need any technical background to create the field.

• Go to Jira settings > Dynamic Custom Fields for Jira "Field Configuration"
• Select "attachment filenames" from the template dropdown
• Click save

Now you can add the field to your issues like any other Jira custom field.

[mauricio.groth]

Hi @Abdelrahman R

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

You can use this query to Find issues with an attachment name containing "screenshot". 

attachmentName ~ "screenshot"  

Check out the documentation for more examples.

If you have any other questions, please contact our support. We’ll be happy to help you!
Best regards,
Maurício

[Jack Brickey]

Unfortunately OOTB it is not possible to search attachments by name or content. You could consider an add-on like scriptrunner which supports searching of attachmentName

[Jack Brickey]

@Abdelrahman R ,  Mauricio offered another good and popular addon. I thought I would also add a list for consideration/assessment via this Marketplace search - https://marketplace.atlassian.com/search?query=jql%20extension