MySQL / PostgreSQL
| Code Block | ||
|---|---|---|
| ||
-- 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; |
...
| Issue | filename | Stored as |
|---|---|---|
| SQLREPORT-27 | sqlReport.png | 10906 |
| SQLREPORT-27 | config.png | 10907 |
| SQLREPORT-27 | support.txt | 10908 |