This query allows you to convert HTML format from Comments
select i.`KEY` as `Issue`, FORMATHTML(ic.BODY) as `Comment` from ISSUE i join ISSUECOMMENT ic on ic.ISSUEID = i.ID where i.JQL = 'project = PROJECTNAME'
This query allows you to convert HTML format from Comments
select i.`KEY` as `Issue`, FORMATHTML(ic.BODY) as `Comment` from ISSUE i join ISSUECOMMENT ic on ic.ISSUEID = i.ID where i.JQL = 'project = PROJECTNAME'