How do i retrieve glide record elements from array

[rajendravunnam]

Hello,

I am new to ServiceNow and Javascript. I am having hard time in retrieving glide records from array:

This is the code i have. I ran it as a background script.

I would like to retrieve the all the columns from the record. I tried in many ways, but the last statement always returns NaN.

var array1=new Array();

var gr = new GlideRecord('change_request');

//gr.addQuery('state', 'New');

gr.query();

gs.log("Row count=",+gr.getRowCount());

var x = new GlideRecord();

while(gr.next())

{

array1.push(gr.getDisplayValue().toString()); //I tried gr.number,gr.sys_id, gr.number.getDisplayValue().......

}

gs.log('array length',+array1.length);

gs.log('printing 4th element',+array1[3].number.getDisplayValue());//---> This is returning NaN

output:

32: Row count=

32: array length

NaN: printing 4th element

Any help is appreciated..

Thanks!

Raj

[Sanjeev Kumar1]

Hi,

Try this

var array1= [];

var gr = new GlideRecord('change_request');

//gr.addQuery('state', 'New');

gr.query();

while(gr.next())

{

array1.push(gr.number+'');

}

gs.print(array1);

[rajendravunnam]

Hi Sanjeev,

This is working. Thank you very much.

[Sanjeev Kumar1]

Please mark it Correct

[Jeet]

Hi Brother,

var crList= [];

var gr = new GlideRecord('change_request');

//gr.addQuery('state', 'New');

gr.query();

while(gr.next())

{

var changeRequest = {};

changeRequest.number = gr.getDisplayValue("number");

changeRequest.type = gr.getDisplayValue("type");

cahngeReuest.category = gr.getDisplayValue("category");

....

........

..........

crList.push(changeRequest );

}

gs.print(crList);

PS: Mark correct bro if it is helpful for you..!!

Regards,
Jeet