Is there any way to capture the user(s) approving a step? I am using 8.0 SP1. Wondering if I could capture in a field using a rule on transition and the [SYS.USERNAME] token. Not sure if anyone has done this already? I would probably need some way to copy what exists in that field then add this additional name to it, since there could be multiple approvers. Any advice?
You could use the following query to to capture the user who hs approved a paritcular step. You may need to modify a bit to suit you requirements.
select ku.user_id, ku.username, kr.request_id , kws.step_name, kws.STEP_TYPE_CODE from kcrt_requests kr , kwfl_step_transactions kst, knta_users ku, kwfl_workflow_steps kws, kwfl_workflow_step_security kwss, knta_user_security kus, kwfl_resolved_sec_tokens krst, knta_security_groups ksg Where 1=1 and kst.top_instance_source_set_id = kr.request_id and ku.user_id = kst.last_updated_by and kst.workflow_step_id = kws.workflow_step_id and kst.top_instance_source_type_code = 'IR' and kus.user_id = ku.user_id and ksg.security_group_id = kus.security_group_id and krst.source_id = kr.request_id and krst.workflow_step_security_id = kwss.workflow_step_security_id and krst.security_group_id = kus.security_group_id and kws.step_name = and kr.request_id =