glide record for loop help

[Gary22]

hi All , 

i have a list of incidents stored in a variable ( separator is comma )

var1 = 'inc1 , inc2 , inc3'

In my server side script i need to do a glide on the incident table and query for each incident number , one by one ( first query for inc1 , then query for inc 2 in a loop ).This is a basic scripting question i know but need some hint on how to fetch the comma separated values into the for loop one by one , , so that i can then do a glide query . 

thanks a lot in advance

[Harish Bainsla]

hi check below code

var var1 = 'inc1, inc2, inc3';

var incidentNumbers = var1.split(', ');

for (var i = 0; i < incidentNumbers.length; i++) {

    var incidentNumber = incidentNumbers[i].trim();

    var gr = new GlideRecord('incident');

    gr.addQuery('number', incidentNumber);

    gr.query();

    if (gr.next()) {

        gs.print('Incident ' + incidentNumber + ' found. Do something with it.');

    } else {

        gs.print('Incident ' + incidentNumber + ' not found.');

    }

[Vallabh Baradk2]

Hello @Gary22 ,

You can try below code:

var a='INC6488096,INC6481267,INC6481266';

var gr1=new GlideRecord('incident');

gr1.addEncodedQuery('numberIN'+a);

gr1.query();

while(gr1.next()){

gs.print(gr1.getValue('number'));

}

Output:-

Please mark correct or helpful if it really works for you.

Regards,

Vallabh