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]

its not working there also. Requested_for is still the same who logged in

[sanjeev28 k]

And when I checked in logs , by putting gs.log("sanjeev1"+ req.query()); its saying the above thing and its not getting into

if(req.next()) condition

[Pradeep Sharma]

Hello Sanjeev,

Please check.It is working fine now

[sanjeev28 k]

Its working for you, but let me try in my case

[Pradeep Sharma]

create a BR on Request table and let me know if you have any questions.