Not able to Query a table successfully

sanjeev28 k
Giga Expert

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();

1 ACCEPTED SOLUTION

Hi Kalai, i got my answer, and thanks for your kind support,


I just removed req.update(); from your code. and used only the below code. And now I am getting only single request.




var req= current.request.getRefRecord();


req.requested_for= '01f3aba9141c390048f5dab33584817c';



Thanks kalai and pradeep


View solution in original post

30 REPLIES 30

Can you try to replicate the same on any demo instance.



Sent from my android device.


Ill try that


sanjeev28 k
Giga Expert

Hi Pradeep,



Same happened in other instance also.


Can you please ping the demo instance where you did so that I can take a look


Hi Pradeei,



Srry I tried in test instance, but Ill try in demo one and will give you the update!!