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]

Hi Kalai,

Please find the screenshot that is getting auto approved

[Kalaiarasan Pus]

This will work but may not be recommended

var req= current.request.getRefRecord();

req.requested_for= '01f3aba9141c390048f5dab33584817c';

req.setWorkflow(false);

req.update();

[Kalaiarasan Pus]

Paste this in a update business rule and not on insert + update business rule

[sanjeev28 k]

It dint worked

[Kalaiarasan Pus]

On which table is the business rule?   Sc_req_item? Is it a after update rule?