SQL query to get all attachment names with issue key from a Particular project

[manikanta ch]

Hello all,

SQL query to get all attachment names with issue key from a Particular project?. 

Database - Postgresql

Any help would be greatly appreciated.

Thanks in advance,

Ch

[Piyush_Annadate]

Try with: 

ELECT  pkey, CI.NEWVALUE, CI.NEWSTRING FROM jiraissue JI,
 changegroup CG,
 changeitem CI
 WHERE JI.ID = CG.issueid
   AND JI.PROJECT IN (select id from project
                    where pname = 'My Project Name')
   AND CG.ID = CI.groupid
   AND CI.FIELD = 'Attachment'
   AND JI.issuestatus IN (select ID from issuestatus
                    where pname = 'Closed');