Control executor field have to set

[Shaik22]

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.

[Murthy Ch]

Hello @Shaik22 

Not really understood the last part of what you said. What I understood is you want to update the 81 control executions in your contol table??