Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This query allows you to convert HTML format from Comments

Code Block
languagesql
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'
Info

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…

Image Added

Image Added