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 5 Current »

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
  • No labels