SQL to get attachment size with project key and issue key

[Bhargavi Vasa]

I have SQL to get project key,issue key and attachment id's,looking for attachment size in byes in jira version 8.20.5

Example :

Project Key , Issuekey , Attachment ID, attachmentsize in bytes

SELECT

   p.pkey AS project_key,

   ji.issuenum AS issue_key,

   fa.id AS attachment_id

FROM

project p

JOIN

   jiraissue ji ON p.id = ji.project

JOIN

   fileattachment fa ON ji.id = fa.issueid

[Jim Knepley - ReleaseTEAM]

There's a "filesize" field in the "fileattachment" table, add it as part of your SELECT statement and that might get you what you want.