Adding RITM comments and work notes to the sc_task form activities stream

nicholar · ‎03-16-2017

Does anyone know if it is possible to add the comments from the RITM of a task to the task's activites (filtered) stream?

I've been playing around with this and can't seem to get the comments to appear within the activities stream.

I've tried adding the request_item.work_notes, comments, etc. to the glide.ui.sc_task.activity.fields.

but when I add request_item comments_and_work_notes to the task form view this is how they appear:

The fields to post to the ritm comments or work notes appear to get fed through the activities formatter but the comments and work notes themselves don't seem to and I'm not sure why.

Any help or guidence is greatly appreciated.

amlanpal · ‎03-16-2017

Hi Anthony,

Please write a before Update Business rule in the Requested Item (sc_req_item) table with the conditions and script as below:

Table: Requested Item (sc_req_item)

When: before

Update: Checked

Advance: Checked

Filter conditions: Work notes changes

Script:

var gr = new GlideRecord('sc_task');

gr.addQuery('request_item',current.sys_id);

gr.query();

if(gr.next())

{

//It will update the Catalog task's Work notes with the Requested item's Customer Communication

gr.work_notes= "The following Work notes have been added :\n " + current.comments;

}

Once you are done with the above Business rule, just make sure that the 'glide.ui.sc_task_activity.fields' system property should have 'work_notes' in its value.

I hope this helps.Please mark correct/helpful based on impact

View solution in original post

amlanpal · ‎04-30-2019

Hi Santosh,

Please open any existing Catalog Task record being an Admin and click on 'Configure available fields' referring the below image. Then verify that whether the Available Slush Bucket contains the Work Notes, if not please add the field. You do not need to navigate for any system property if you opt for this approach to verify/modify.

Hope this helps. Please mark Helpful/Correct based on the impact.

Regards,

Amlan

Margarida · ‎11-22-2022

Hey there amlanpal!

Allow me to ask you the following question, please: What about if I want to display in Activity Stream the automatic updates from the form variables by the flow? Such as this one:

Thanks in Advance!

Michael Hays · ‎02-27-2020

I was able to get it to work.

change his code

the advance BR

var gr = new GlideRecord('sc_task');
gr.addQuery('parent', current.sys_id);
gr.query();
if (gr.next()) {
//It will update the Catalog task's Work notes with the Requested item's Customer Communication
gr.comments = "The following Comments have been added from the Requested Item :\n " + current.comments;
gr.update();
}

this was added from the task activities