Skip to end of metadata
Go to start of metadata
You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 2
Next »
MySQL / PostgreSQL
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 |