background scripts returning "undefined" value

[ramandeep]

Friends,

I am running below background script. As shown in output, count is 1 but number returned is "undefined". Please help me in getting the correct number?

var abc = new GlideRecord('change_task');

abc.addQuery('number', 'CTASK0023280');

abc.query();

var count=abc.getRowCount();

//gs.log('Parent is '+ abc.sys_id);

gs.log('count is '+count);

gs.print('Number is ' + abc.number);

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[0:00:00.006] Script completed in scope global: script

---

*** Script: count is 1
*** Script: Number is undefined

[ramireddy · Accepted solution]

you need to iterate the table after querying.

var abc = new GlideRecord('change_task');

abc.addQuery('number', 'CTASK0023280');

abc.query();

var count=abc.getRowCount();

//gs.log('Parent is '+ abc.sys_id);

gs.log('count is '+count);

while(abc.next())

{

gs.print('Number is ' + abc.number);

}

[santoshsahoonis]

add a line:   abc.next();

var abc = new GlideRecord('change_task');

abc.addQuery('number', 'CTASK0023280');

abc.query();

abc.next();

var count=abc.getRowCount();

//gs.log('Parent is '+ abc.sys_id);

gs.log('count is '+count);

gs.print('Number is ' + abc.number);

[Anurag Tripathi]

you missed abc.next() buddy!!

[Midhun1]

Hi,

After var count=abc.getRowCount();

add below:

if(abc.next())

{

gs.log('count is '+count);

gs.print('Number is ' + abc.number);

}