Hello,
I didn't have time to reply before but I was able to create a script from a couple of posts including some of the ones mentionned here.
Still I was missing the part where the elements pushed in the array had to be copied in a glide list of another table. So here is my final script.
var rpQuery1 = 'u_tache_principale.active=true';
//var rpQuery2 = 'number=prjtask0107247';
var taskList = [];
var taskGR = new GlideRecord(table);
taskGR.addEncodedQuery(rpQuery1);
//taskGR.addEncodedQuery(rpQuery2);
taskGR.query();
gs.print('Task Count: ' + taskGR.getRowCount());
while(taskGR.next()) {
gs.print('Task ID: ' + taskGR.sys_id);
taskList.push(taskGR.sys_id.toString());
}
gs.print('Task List: ' + taskList);
for(var i=0; i<taskList.length; i++ ) {
gs.print('Task ID: ' + taskList[i]);
var userList = [];
var arrayUtil = new ArrayUtil();
var resPlan = new GlideRecord('resource_plan');
resPlan.addQuery('task', taskList[i]);
resPlan.addEncodedQuery('user_resourceNSAMEAStask.assigned_to');
resPlan.query();
gs.print('Count: ' + resPlan.getRowCount());
while(resPlan.next()) {
if(arrayUtil.contains(userList,resPlan.user_resource.sys_id.toString())) {
continue;
}
userList.push(resPlan.user_resource.sys_id);
}
gs.print('User list: ' + userList);
var getTask = new GlideRecord('task');
getTask.get('sys_id', taskList[i]);
gs.print('Task ID: ' + getTask.sys_id);
getTask.additional_assignee_list = userList.join(',');
getTask.update();
}
Thank you all for your time and inputs.
