Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Sql query to search the contents of all attachment including file.

Kalyan Kumar Das
Contributor
June 15, 2021

I need a sql query to search the contents of all attachments, including file attachments.I am using mysql database.

Please suggest. 

2 answers

1 vote
Payne
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
June 15, 2021

SQL cannot be used to search the contents of attachments; only attachment metadata is stored in the database; the attachments themselves are stored on the file system.

0 votes
Rilwan Ahmed
Community Champion
July 11, 2023

Hi @Kalyan Kumar Das ,

if you are looking to know all tickets which has attachments, then use JQL as below

project = "ABC" and attachments is not EMPTY

Suggest an answer

Log in or Sign up to answer