We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Transform Map Script

aagman4
Tera Contributor
Control table extends table - Control/Risk. Transform map is on Control/Risk table. I wanted to update custom fields u_key_entity and u_key_system present in Control table. I am using below code in Transform Script but it is being ignored with error - Invalid map target u_key_system does not exist in table sn_compliance_control
 
if (source.u_class == 'Control') {
        var controlInfo = new GlideRecord('sn_compliance_control');
        controlInfo.addQuery('number', source.u_number);
        controlInfo.query();
        if (controlInfo.next()) {
            controlInfo.u_key_entity = source.u_internal;
            controlInfo.u_key_system = source.u_other;
        }
    }
 
Let me know if I am missing anything here.
 
Thanks in advance!
0 REPLIES 0