How can I list all closed incidents showing Resolved By not a member of the Resolved By Group?

[JLeong]

Good day!

How can I list all closed incidents showing Resolved By not a member of the Resolved By Group in Flow Designer?

I need to update all closed incidents with mis matching Resolved By and Resolved By Group. Resolved By Group should be a group that Resolved By is a member of.

The updating part in Flow Designer is easy but I need to list the records first.

Thank you in advance.

Regards,

Jocelyn

[Chavan AP]

hey

1. query incident table

2. get all the resolved incident along with resolved by

3. for each resolved by query group member table

4. then update incident with respective group

regards

aj

[JLeong]

Hi Ajay,

I appreciate your response. I was able to do this in Flow Designer, but I need a list first before updating.

Regards,

Jocelyn

[Jaspal Singh]

Hi,

Can you try using below script in background script.

var agis;
var usis;
var inciis=new GlideRecord('incident');
inciis.addQuery('number','INC000001'); //Try for 1 record of incident
inciis.query();
while(inciis.next())
{
 agis=inciis.resolving_group; //replace resolving_group with appropriate field name
 usis=inciis.resolved_by;
 var usrmember=new GlideRecord('sys_user_grmember');
 usrmember.addQuery('user',usis);
 usrmember.addQuery('group',agis);
 usrmember.query();
  if(usrmember.next())
   {
    //gs.print('Yes');
   }
else
{
gs.print('Number is '+inciis.number);
}

}

Thanks,

Jaspal Singh

Hit Helpful or Correct on the impact of response.