gliderecord error

[Hafila Hatta]

hi. i keep getting this error in my flow. could anyone help to with this error? not sure if my script is the issue

here is my script:

var acc_name = fd_data._3__for_each.item.accessory;

var var_count = new GlideRecord('u_inventory_accessories_count');

var_count.addQuery('sys_id', acc_name);

var_count.query();

if (var_count.next()) {

    var result = var_count.getValue('u_current_stock_count');

    var new_result = result - 1;

    return new_result;

}

[Ankur Bawiskar]

@Hafila Hatta 

did you try to add logs and see?

are you querying with the correct table and field?

var acc_name = fd_data._3__for_each.item.accessory;

gs.info('Acc name' + acc_name);

var var_count = new GlideRecord('u_inventory_accessories_count');
var_count.addQuery('sys_id', acc_name);
var_count.query();

if (var_count.next()) {
	gs.info('Inside record found');
    var result = var_count.getValue('u_current_stock_count');
    var new_result = result - 1;
	gs.info('result' + result);
    return new_result;
}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Hafila Hatta]

yes, it is the correct table and field. getting the same error using ur script

[Ankur Bawiskar]

@Hafila Hatta 

did you add logs as per I shared and check which came fine?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Hafila Hatta 

Any update to this?