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_zqt9p1

@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';