how can I create a jira report with the latest comments in each issue?

[Sagayaraj Arulanandam]

I'm trying to find an option using JDL to generate a report of comments (latest or by specific dates) for specific set of issues. However, I'm unable to find such an option within JQL. Can someone help? 

[Sreenivasaraju P]

You can use Jira Misc Custom Fields plugin and calculate the sub task field value on parent ticket 

https://marketplace.atlassian.com/apps/27136/jira-misc-custom-fields?hosting=server&tab=overview

for (Issue subtask : issueObject.getSubTaskObjects()) {
 CustomField number=customFieldManager.getCustomFieldObject("customfield_XXXX");
 Double numbervalue=(Double)subtask.getCustomFieldValue(amountField);
 Sum = sum + numbervalue;
 
 }

[Alexey Matveev]

Hello,

You would need an add-on for it.

For example, you could use the Power Custom Fields Premium add-on:

https://marketplace.atlassian.com/apps/1210749/power-custom-fields-premium?hosting=server&tab=overview

You could create a sil custom field with a code like this and add this field to the view screen of the Task issue type:

number sum = 0;
string[] keys = subtasks(key);
for(string key in keys){
 #{number field name} = #{number field name} + %key%.#{number field name};
}

This custom field would show the sum of the Number Field custom field for all subtasks of the task.