Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-10-2017 01:57 PM
Hi robhaas
You need to put this coe in the onbefore transform script. You do not need the business rule anymore.
if(action=='insert'){
//parse the values
var gr= new GlideRecord("table name");
gr.addQuery('<field name of SYSTEM on target table>',<parsed value of SYSTEM from source field>);
gr.addQuery('<field name of GROUPNAME on target table>',<parsed value of GROUPNAME from source field>);
gr.query();
if(gr.next()){
gr.<approver field name on target table>=source.<approver field name>;
gr.update();
ignore=true;
}