How to add single quotes to each array item

[mballinger]

Hello,

I have a script that builds a comma separated array. How can I add single quotes to each item in the array?

This is what I have so far:

var array = [];
var number = 'number';
var gr = new GlideRecord('incident');
gr.addEncodedQuery('state=3');
gr.query();
while(gr.next()) {
    array.push(gr.getValue(number));
}

var newGr = new GlideRecord('problem');
newGr.addEncodedQuery('nameLIKEonHold');
newGr.query();
if(newGr.next()) {
    newGr.u_problem_incidents_on_hold = array;
    newGr.update();
}

Result should Look something like:

'INC000001', 'INC000002', 'INC000003', 'INC000004', 'INC000005', 'INC000006'

Currently my results look like this:

INC000001,INC000002,INC000003,INC000004,INC000005,INC000006

[bammar · Accepted solution]

Near the top

var number = 'number';

try to convert this value to a sting if its not already, maybe add this line

number = "'" + number + "'";

That might just do it...

[Pranesh072]

try this 

var array = [];
var number = 'number';
var gr = new GlideRecord('incident');
gr.addEncodedQuery('state=3');
gr.query();
while(gr.next()) {
    array.push("'"+gr.getValue(number)+"'");
}

var newGr = new GlideRecord('problem');
newGr.addEncodedQuery('nameLIKEonHold');
newGr.query();
if(newGr.next()) {
    newGr.u_problem_incidents_on_hold = array;
    newGr.update();
}

[Pranav Bhagat]

@mballinger 

A more simple way

var array = ["f","test"];

var res = "'"+array.join("','")+"'";

gs.print(res);