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 · ‎03-20-2017

Hi Anthony,

Unfortunately there is no way as you have mentioned. As you know, request_item.comments is not available inside the Configure activities for the sc_task table, all you want to do is to populate the comments of the Requested item table via any field which is there in the sc_task table. Until and unless you do not do this things the comments from the requested item won'y populate in the activity tab.

There was a similar requirement in my earlier project. Hence we opted the same way to copy the comments/work notes to the sc_task record and it worked. Thought to provide you the same approach which works perfectly in this kind of scenario.

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

nicholar · ‎03-20-2017

Thanks amlanpal It would of been nice not to have to copy to the task, but I'm sure that your suggestion could work for our purposes.

amlanpal · ‎03-20-2017

Hi Anthony,

Glad to know that it would help. Pleasure is mine.

amlanpal · ‎03-22-2017

Hi nicholar,

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

If you are viewing this from the community inbox you will not see the correct answer button. If so, please review How to Mark Answers Correct From Inbox View

santoshkomerave · ‎04-30-2019

Hi Amlanpal,

I couldn't able to see the property - 'glide.ui.sc_task_activity.fields' in sys_properties table. I am checking this in Madrid release.

I have checked on Kingston and London releases as well. I couldn't see this property there as-well.

Any help/suggestions here?

Thanks,

Santosh