Hi,
'control executor(Reference - user)' field is on controls[sn_compliance_control] table. 'Evidence Execution(choices - Manual, Automatic)' and 'Assigned to' fields on Control execution[sn_audit_control_execution]table.I have applied conditions to the Control Execution table, specifically that the Control is not empty, Evidence Execution is manual, Type is SOX, and State is not retired. Based on these conditions, there are 81 existing controls for which I want to set the Control Executor field according to the Assigned To field in the Control Execution table. How to implement this? By using script, Can you please provide script.
