Add one user to watchlist of Request and it should reflect on watchlist of RITM, SCTASK. can anyone help me on this how to achieve it.

[SP22]

Add one user to watchlist of Request and it should reflect on watchlist of RITM, SCTASK. can anyone help me on this how to achieve it.

[SumanthDosapati]

Hi,

Write an after business rule on sc_request table

(function executeRule(current, previous /*null when async*/) {

	var ritm = new GlideRecord('sc_req_item');
	ritm.addQuery('request',current.sys_id);
	ritm.query();
	while(ritm.next())
		{
			
			var sc = new GlideRecord('sc_task');
			sc.addQuery('request_item',ritm.sys_id);
			sc.query();
			while(sc.next())
				{
					sc.watch_list = current.watch_list;
					sc.update();
				}
			
			ritm.watch_list = current.watch_list;
			ritm.update();
		}

})(current, previous);

Mark as correct or helpful if it works.

Regards,

Sumanth

[SP22]

I have tried this but if a user added in watchlist of request automatically. can it reflect on RITM & SCTASK. Please help me on this.

[SumanthDosapati]

It will still work even if watchlist users are added automatically unless if the users are added using any script that uses "setWorkflow(false)".

If that is the case then write an onLoad client script on RITM and sc task tables and make an ajax call to a script include and set the watchlist.

Mark as correct or helpful if it works.

Regards,

Sumanth

[SumanthDosapati · Accepted solution]

Change the business rule as below

After  -  Insert and Update

condition -  Watchlist in Not Empty

[tanuja3]

We can achieve it by writtting the After Business rule on sc_request table defining the filter condition as whenever Watchlist  changes.

(function executeRule(current, previous /*null when async*/) {

	var ritm = new GlideRecord('sc_req_item');
	ritm.addQuery('request',current.sys_id);
	ritm.query();
	while(ritm.next())
		{
			
			var sc = new GlideRecord('sc_task');
			sc.addQuery('request_item',ritm.sys_id);
			sc.query();
			while(sc.next())
				{
					sc.watch_list = current.watch_list;
					sc.update();
				}
			
			ritm.watch_list = current.watch_list;
			ritm.update();
		}

})(current, previous);