Hi,
the issue here is target field on sys_email is document_id so possibly it is not able to query
Use Run Server Side Script Step instead of Step 22 which is Record Query
(function(outputs, steps, stepResult, assertEqual) {
// add test script here
var STEP_10_SYS_ID= 'd9f8dd67db805410bea7550a48961930'; // step sys_id of Step 10
var val = steps(STEP_10_SYS_ID).first_record;
var emailRec = new GlideRecord('sys_email');
emailRec.addQuery('target_table', 'sc_req_item');
emailRec.addQuery('instance', val);
emailRec.query();
if(emailRec.next()){
outputs.table = 'sys_email';
outputs.record_id = emailRec.sys_id;
message = 'Found Email';
stepResult.setOutputMessage(message);
stepResult.setSuccess();
return true;
}
else{
message = 'Not Found Email';
stepResult.setOutputMessage(message);
stepResult.setFailed();
return false;
}
})(outputs, steps, stepResult, assertEqual);
Then For Step 23 do this select the output of the previous Run Server side script step
"Open the 'Email' form with id '{{Step 22: Record Query.Record id}}'
Regards
Ankur
Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
