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

Question

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

Please suggest.

Rilwan Ahmed · Answer

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

Payne · Answer

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.