Exporting comments in JIRA Issues using normal csv export.

[Kosala]

      I want get export of comments in JIRA Issues to a Excel.   If not want to know how the Comments are stored in the JIRA database ?

[Veera · Accepted solution]

@Kosala 

Refer to KB: How to add comments to Excel export

If you have database access, you can run below SQL.

SELECT P.pkey||'-'||JI.issuenum as issuekey, JA.actionbody
FROM jiraaction JA
JOIN jiraissue JI ON JA.issueid = JI.id
JOIN project P ON JI.project = P.id
WHERE JA.actiontype = 'comment';

[Max Stoaks]

Do end users have access to the db for a Jira cloud instance?