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.png | 10906 |
SQLREPORT-27 | config.png | 10907 |
SQLREPORT-27 | support.txt | 10908 |