Existing record is not getting updated using workflow run script

[Yesh]

Hi Team,

I am trying to update the existing record using workflow run script. It is querying the record and getting inside the loop, but not updating the values in the fields i am trying to update.

I have written the script like this:

var cred = 0;
var debt = 0;
var bal = 0;

var insjeli = new GlideRecordSecure('x_je_line_item_stagging_table');
insjeli.addQuery('number', current.sys_id);
insjeli.query();

while(insjeli.next()) {
var color = insjeli.getDisplayValue('color');
var amount = insjeli.getValue('amount');
if (color == 'Credit') {
cred = cred + parseInt(amount);
gs.info('Credit : ' + cred);
} else if (color == 'Debit') {
debt = debt + parseInt(amount);
gs.info('Debit : ' + debt);
}
}
bal = debt - cred;
gs.info('Balance : ' + bal);

var updateJE = new GlideRecordSecure('x_je_stagging_table');
updateJE.addQuery('sys_id', insjeli.getValue('number'));
updateJE.query();
if (updateJE.next()) {
gs.info('.........................'); //logging this message
updateJE.cred = cred;
updateJE.debt = debt;
updateJE.balance = bal;
updateJE.update(); // not updating the field values 
gs.info(updateJE.getValue(cred)); // returning null, means value didn't get updated
}

I don't know where i have done wrong. 

Any suggestions will help.

Thanks

[John Dahl]

Your query is comparing a number value to a sys_id. The resulting updateJE GlideRecord is mode likely empty and would not result in any updates.

updateJE.addQuery('sys_id', insjeli.getValue('number'));