Skip to main content
Skip table of contents

Finding Attachment Location

MySQL / PostgreSQL 

SQL
-- Find Attachment Location
SELECT CONCAT(p.pkey,'-',ji.issuenum) AS "Issue", f.filename, f.id as "Stored as" 
FROM fileattachment f, jiraissue ji, project p 
WHERE ji.ID = f.issueid AND p.id = ji.project;

Sample Result

Issue  filename Stored as 
SQLREPORT-27 sqlReport.png10906
SQLREPORT-27 config.png10907
SQLREPORT-27 support.txt10908
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.