Hello guys!
Can anyone tell me if:
Is there any way to create a measure that lists the last Internal type comment?
I need to create a table that lists this information on how to measure.
Hi @Fabio.Santos,
It looks like you already have a JavaScript calculated custom field that looks for the last issue comment. eazyBI does not receive information if a comment is internal or visible to customers as well.
You may enhance the JavaScript code with the function getDocument to retrieve additional attributes for each comment and check if it is internal or external:
The code for JavaScript calculated custom field might look like this:
[jira.customfield_lastintcomment]
name = "Last Internal Comment"
data_type = "text"
javascript_code = '''
if (issue.fields.comment && issue.fields.comment.comments) {
for (i=issue.fields.comment.comments.length-1; i>=0; i--) {
var commentItem = issue.fields.comment.comments[i];
var result = getDocument("comment/" + commentItem.id + "/properties/sd.public.comment",{ignoreErrors: [404]});
if(result && result.value) {
if(result.value.internal) {
issue.fields.customfield_lastinternalcomment=commentItem.body;
break;
}
}
}
}
'''
In import options validate the JavaScript code Before applying changes to the Javascript code, double-check the customfield name “customfield_lastintcomment” to match your environment.
When you do the changes in advanced settings, make sure to re-import the custom field “Last Internal Comment”.
More details on how to validate and apply changes are here: JavaScript calculated custom fields.
Related topics on how to import comments:
- Calculating the number of comments - by specific USER - #2 by zane.baranovska
- Graph by comment count - #2 by martins.vanags
- Time to first response report without the standart SLA - #2 by roberts.cacus
- Exclude reporter on First comment date - #2 by daina.tupule
Best,
Zane / support@eazyBI.com
1 Like
@Marcelo_Ignacio_Cid1, please, follow the documentation on JavaScript calculated custom fields where to place them, and how to test them: JavaScript calculated custom fields.
Note that
- The settings and the JavaScript code should be placed in the eazyBI advanced settings; this section is available to Jira admins and eazyBI admins: Define calculated custom field in eazyBI advanced settings
-
Test the JavaScrip part (code between
javascript_code = '''and''') on individual issues to see if the code requires some adjustments: Validate the Javascript code before using it in the custom field definition
Best,
Zane / support@eazyBI.com
