Business Rule that checks to see if catalog item variable matches table value and updates

[Jayce Antrum]

Hi all,

I'm new to scripting in ServiceNow and have a requirement that I'm a little stuck on. This is preferred to be done in a business rule.

I have a catalog item with a variable called Workday Requisition Number (ritm_supplies_workday_requisition_number).This is a string field. The requirement is that when this is filled in with a requisition number, automatically update another read-only field on the RITM/TASK called Workday PO Number (ritm_supplies_workday_po_number). Workday PO number is a reference field to the proc_po table and would pull in a PO record.

On the proc_po table, we have a field called "u_workday_purchase_request". Essentially what I want to do is when a user enters their workday requisition number on the RITM variable, I want the system to query the proc_po table and if there is a matching value in the "u_workday_purchase_request" field, then automatically update the Workday PO Number field on the catalog item (ritm_supplies_workday_po_number) to the PO record that has the matching purchase requisition number.

High level flow would be:

User enters Workday Requisition Number on RITM variable > IF this Workday Requisition Field on the RITM EQUALS the "u_workday_purchase_request" field on the purchase order table, THEN UPDATE the Workday PO Number (ritm_supplies_workday_po_number) field on the RITM ticket to the corresponding PO record.

See below for the current code of my before business rule although I think it's pretty wrong at the moment. Thank you in advance. I have this currently on the sc_req_items table.

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

	var lookup= new GlideRecord('proc_po');


lookup.addQuery('u_workday_purchase_request'),current.u_workday_purchase_request,

lookup.query();


if(lookup.next())
{


current.setDisplayValue('ritm_supplies_workday_po_number',lookup.getDisplayValue());


}

})(current, previous);

[anilsa]

thank you getting the same and sloved now