Not able to Query a table successfully

[sanjeev28 k]

Hi,

I am taking the request no. from a request item (sc_req_item) table based on some conditions and then querying that request no. into request table (sc_request) and then assigning a static value of a particular user to the field of requested_for'. But Its not getting into req.next() loop. and req.query is giving a "undefined " response which I checked in logs. Please Help.

var req_no= current.request;                   // getting a request no. from sc_req_item table

var   req = new GlideRecord('sc_request');

req.addQuery('sys_id', req_no);

req.query();                   // showing   as   'undefined' response in logs

if(req.next()){               // showing   as   'false' response in logs

req.requested_for= '01f3aba9141c390048f5dab33584817c';     // Assigning a static user sys_id to requested_for field

req.update();

[sanjeev28 k]

But I have a conditions which should be checked from sc_req_item table. so I have to use sc_req_item table instead of sc_request table to run business rule