Document toolboxDocument toolbox

Finding Attachment Location

MySQL / PostgreSQL 

-- 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