Display comments in easyBI report

Questions & Answers
1

I want jira comments to be displayed in my easyBI report. I checked the community page throughly, i could find one thread where somebody had some steps, but those were two technical. If somebody could explain in an easier manner, it would help me.
Thanks

2

Hello Still_Figuring,

Thank you for reaching out to the community! I understand you’re looking for a less technical explanation, so I’ll do my best to keep it straightforward.

First, it’s important to know that eazyBI is primarily designed for analyzing and visualizing structured data, which is why comments (being large text fields) are not imported by default. However, there is a way to include them with some additional configuration.

Here are the steps to import comments:

  1. You’ll need to add a piece of JavaScript code to your eazyBI advanced settings which tells eazyBI how to grab the comments from Jira (code example below).

  2. Once the code is added, you’ll see a new custom field option named “All Comments” in the Source Data Jira import options to import as property.

  3. After importing, you can use this new field in your reports.

While this process requires some technical setup, this is how to bring comments into eazyBI.

You can find detailed instructions about eazyBI advanced settings here: Global calculated fields
The JavaScript code to add comment with date and comment author name:

[jira.customfield_all_comments]
name = "All Comments"
data_type = "text"
json_fields = ["comment"]
javascript_code = '''
var commenta = new Array();
var allcomments = issue.fields.comment;
if (allcomments && allcomments.comments ) {
  var comments = issue.fields.comment.comments;
  for (var i = 0; i < comments.length; i++) {
    var comment = comments[i];
	  var commentdate = comment.created.toString().substr(0,19);
      commenta.push( commentdate + ', ' + comment.author.displayName + ': ' + comment.body );
      }
  issue.fields.customfield_all_comments = commenta.join("\n");
}
'''

If you have any questions about specific steps or need further assistance, please don’t hesitate to ask!

Best regards,
Ilze