How to add multiple record values to one array value?

[sainath3]

Hi Team,

I have two tables,

1.Incident

2.Personal incident,

Below are the screenshots of table list view.

Incident table: Here "Incident IDs" field having multiple incidents

Personal Incident table:Here having two fields(Incident number, Comments)

Requirement:

Fetch all the comments from Personal incident table to Incident table(Field-name:Personal comments) with respective  Incident IDs field from incident table.

Ex:Incident Id's :INC0009005,INC0009009, So in Personal comments should have two comments :09876,hello

Note:Incident fields are string type in both tables.

[Ravi9]

can u share the code u have tried so far ? 

[sainath3]

Hi Ravi,

Here is my code

var inc=GlideRecord('incident');
    inc.addNotNullQuery('u_incident_ids');
    inc.query();
while(inc.next()){
    
    var perinc=GlideRecord('u_personal_incidents');
    perinc.addEncodedQuery('u_incident_numberIN'+inc.u_incident_ids);
    
    perinc.query();
    var arr=[];
var j = 0;
    while(perinc.next()){
        arr[j]=perinc.u_comments.toString();
    //    gs.log(arr[j].length);
    gs.log(arr[j]);

               j++;
    //inc.u_personal_inc=arr[j];
        //inc.update();
    }
    

}

Output:

*** Script: hi
*** Script: 123456
*** Script: 09876
*** Script: hello

Expected Output:

*** Script: hi,123456
*** Script: 09876,hello

[Anil Lande]

Hi,

Try below:

var inc=GlideRecord('incident');
    inc.addNotNullQuery('u_incident_ids');
    inc.query();
while(inc.next()){
    
    var perinc=GlideRecord('u_personal_incidents');
    perinc.addEncodedQuery('u_incident_numberIN'+inc.u_incident_ids.toString());    
    perinc.query();
    var arr=[];

    while(perinc.next()){
        arr.push(perinc.u_comments.toString());
    //    gs.log(arr[j].length);  

              
    
    }
gs.log(arr.toString());
    
//inc.u_personal_inc=arr.toString();
        //inc.update();
}

Thanks,
Anil Lande

[Anil Lande]

If you want to use your own logic then try below:

var inc=GlideRecord('incident');
    inc.addNotNullQuery('u_incident_ids');
    inc.query();
while(inc.next()){    
    var perinc=GlideRecord('u_personal_incidents');
    perinc.addEncodedQuery('u_incident_numberIN'+inc.u_incident_ids);    
    perinc.query();
    var arr=[];
    var j = 0;
    while(perinc.next()){
        arr[j]=perinc.u_comments.toString();   
        
        j++;
    
    }
    gs.log(arr.toString());
//inc.u_personal_inc=arr.toString();
        //inc.update();

}

Thanks,
Anil Lande