Displaying Additional comments in Email notification.

[Maxwell3]

Hello all,

I am querying the sys_journal_field table to display the Additional comments on email notifications, I am also using getRowCount to display the comments' respective order number next to them on the notifications. 

I am having issues displaying the correct number next to them, please see the example below. The "current status" should say "Update 8" because it is the 8th/last comment on the incident but instead it says "Update:1". The other updates should say Update 5, 6,7 but instead they say 2,3,4.

 I am using the script below for both but separately, the only difference is that I am using gr.setLimit(1) for the "current status" and gr.setLimit(5) for the other ones.

var gr = new GlideRecord('sys_journal_field');
//In the sys_journal_field table, if the element column contains comments as opposed to work_notes & the element_id matches the current id than return the current elements & order in Ascending order.
gr.addQuery('element','comments');
gr.addQuery('element_id',current.sys_id.toString());
gr.orderByDesc('sys_created_on');
gr.setLimit(5);
gr.query();

var i = gr.getRowCount();
gr.next();

while(gr.next()){

if(i>2)
{
i=i-1;
var date = gr.sys_created_on;
var nowDateTime = new GlideDateTime(date);
var gd1 = new GlideDate();
gd1.setValue(nowDateTime.getLocalDate());
var gt = new GlideTime();
gt.setValue(nowDateTime.getLocalTime());
var str = gd1.getByFormat("MM/dd/yyyy");
var t = gt.getByFormat('hh:mm a');
//After re-formatting the GlideDate & GlideTime, assign the values to 'str' and print out the results.

template.print(current.priority.getDisplayValue()+' - UPDATE: '+i.toString()+' received an update on ' + str +' at '+ t +' ET: '+ gr.value.toString());
template.print('<br />');
template.print('<br />');
}
}

[Balaji Jagannat]

Hi Maxwell -

Can you try this code?

var gr = new GlideRecord('sys_journal_field');
//In the sys_journal_field table, if the element column contains comments as opposed to work_notes & the element_id matches the current id than return the current elements & order in Ascending order.
gr.addQuery('element','comments');
gr.addQuery('element_id',current.sys_id.toString());
gr.orderByDesc('sys_created_on');
//gr.setLimit(5); //-- remove this line of code, if you want to set the update with real numbers
gr.query();

var updCount= gr.getRowCount();

var rowLimit = 3; //set based on how many updates you want show
gr.next();

while(gr.next()){

if(updCount>1 && rowLimit >0)
{
rowLimit = rowLimit -1;

updCount= updCount-1;
var date = gr.sys_created_on;
var nowDateTime = new GlideDateTime(date);
var gd1 = new GlideDate();
gd1.setValue(nowDateTime.getLocalDate());
var gt = new GlideTime();
gt.setValue(nowDateTime.getLocalTime());
var str = gd1.getByFormat("MM/dd/yyyy");
var t = gt.getByFormat('hh:mm a');
//After re-formatting the GlideDate & GlideTime, assign the values to 'str' and print out the results.

template.print(current.priority.getDisplayValue()+' - UPDATE: '+updCount.toString()+' received an update on ' + str +' at '+ t +' ET: '+ gr.value.toString());
template.print('<br />');
template.print('<br />');
}
}

**Mark this response as accepted answer and helpful, based on impact. 

[Maxwell3]

Balaji,

Thank you for your input.

The numbering is a little off. I have provided an example below. The numbers on the left are the scripts and the numbers on the right are hard coded. The numbers on the left should reflect the numbers on the right.

[Balaji Jagannat]

Change this line of code var updCount= gr.getRowCount(); To var updCount= gr.getRowCount()-1; And confirm what you see. Also let me know what is the row count when you print gr.getRowCount().

[Maxwell3]

Balaji

The row count matches the number of rows. Your solution is very helpful, I need to do some more testing, to see if it fulfills all the requirements given.

Thank you,

[Balaji Jagannat]

Thanks for letting me know. If this solves your requirement, mark the response as 'accepted answer'.