Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

"Requested For" in RITM not working correctly

Go to solution
anirban300
Kilo Guru

‎08-04-2022 01:39 AM

We have created the variable "On Behalf of" with Type "Reference" in a catalog item. We want to link the data on this field with the field "Requested For" in RITM. So, I have written a "before insert/update"  business rule on the table "sc_request" to link both the field as below

(function executeRule(current, previous /*null when async*/ ) {

    var grRITM = new GlideRecord('sc_req_item');

    grRITM.addQuery('request', current.sys_id);

    grRITM.query();

    while (grRITM.next()) {

        if (!JSUtil.nil(grRITM.variables.requested_for)) {

            current.requested_for = grRITM.variables.requested_for;
       grRITM.update();

        }

    }

})(current, previous);

The flow designer is taking requested for's approval and sending approval. But, still it is sending approval to opened by's approver

Preview file
61 KB
0 Helpfuls
  • 1,752 Views
1 ACCEPTED SOLUTION

Go to solution
Ankur Bawiskar
Tera Patron
Tera Patron
In response to anirban300

‎08-04-2022 02:48 AM

Hi,

Glad to know that my script worked.

If my response helped please mark it correct and helpful to close the thread.

check the requested for field on RITM is field from RITM or dot walked from REQ field?

Also in the XML requested_for field is of RITM so definitely the form field is a dot walked from REQ

so if you wish you can update that as well

(function executeRule(current, previous /*null when async*/ ) {

    var grRITM = new GlideRecord('sc_req_item');
    grRITM.addQuery('sys_id', current.sys_id);
    grRITM.query();
    if (grRITM.next()) {
        if (!JSUtil.nil(grRITM.variables.requested_for)) {
            grRITM.requested_for = grRITM.variables.requested_for;
            grRITM.update();
            
            var req = current.request.getRefRecord();
            req.requested_for = grRITM.variables.requested_for;
            req.update();
            
        }
    }

})(current, previous);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

0 Helpfuls
10 REPLIES 10

Go to solution
PriyaRanji
Tera Guru

‎08-04-2022 02:55 AM

Hello Anirban,

  • Please don't use current.update() in before insert/update BR
  • Instead of business rule, can you update the request for via flow designer using update record action if possible
  • And you can trigger the approval to the flow via requested for (or) using the action get variables and set the value

Hope it helps 🙂 Please do let me know in case of any details needed.

Thanks,

Priyanka R

0 Helpfuls