format COMMENTS

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'

PROJECTNAME* is a tentative name in our queries. Please note that in your JQLs you need to use real names of your Projects, Users, Sprints ,etc.

Before… After…