Issue with Additional comments in Req_item

[snowuser111]

HI,

There is a field in Requested Item --> "Additional comments (customer visible)", but when I put my comments it gets saved and updated in Activity   but not in the same field . How can I apply a condition in one of my Business rule that there are inputs in "Additional comments " since it always shows blank.

I have a business rule in Task table, where I need to apply a condition that if any Additional comments are there, then an event is fired.Also I want to display the value of Additional comments ..............

Anyone can guide please.

Thanks

[snowuser111]

I tried this mail scrip to get the value but it displays   the value at the bottom

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

var gr = new GlideRecord("sc_req_item");

gr.addQuery("request", current.sys_id);

gr.query();

while(gr.next()) {

template.print("<b>Additional Comments:</b>\n" + current.comments.getJournalEntry(-1).getDisplayValue() + " ");

  }

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

6-12-15 04:21:00 EDT - Test, User (Additional comments (customer visible)) Request Automatically Closed as all Line Items were complete

[Tanaji Patil]

Hi,

As per my understanding, here is a solution but it requires creation of 2 BRs and 1
UI policy.

Create a new string field(say Add Comment Reg [u_add_comment_reg])
with max. length 1000/4000 on the 'sc_req_item' table and write a UI policy to
always hide this field.

Write a BRs as shown below

BR1

Table — Requested Item [sc_req_item]

When — before Insert and Update

Order - 100

Filter Conditions — Additional comments[comments] changes

Script —

function onBefore(current, previous) {

u_add_comment_reg = current.comments;

//This will add current Additional comments to Add CommentReg

}

BR2

Table — Requested Item[sc_req_item]

When — before Insert and/or Update (depending on your requirement)

Order - 200

Filter Conditions — Add Comment Reg [u_add_comment_reg] changes

Script —

function onBefore(current, previous) {

gs.eventQueue('item.comment_changed', current, gs.getUserID(), gs.getUserName());

//This triggers notification whenever 'Add Comment Reg' changes

}

Use this 'item.comment_changed' event to trigger the
notification (also on Requested Item[sc_req_item] table). In the notification body
you can use

Additional Comments: ${u_add_comment_reg }

to get the currently entered addition comment.

Hope this helps you

Thanks,

Tanaji

[snowuser111]

Thanks...I will let you know the output once I implement this

[Tanaji Patil]

Ya sure

If you need reference please check demo013. I have done not exact but similar implementation there.

[snowuser111 · Accepted solution]

I have resolved this. Instead of changing in BR , I changed in Email notification by so now its working.