03-06-2014 8:18 AM
I want to search through all the tasks within the workflows and find where a specific role (Agent type AG) is used as an agent. Which tables can i use (or tables with relations) to find this information ?
Roelof Sol
03-06-2014 7:40 PM
role (object type AG) = authorizations
rule (object type AC) = workflow
If it is workflow you are looking for, then the table is swdsexpr with;
exprtype = '013'
expression = 'AC<rule number>'
version = 9999 if you want the active version.
03-06-2014 7:40 PM
role (object type AG) = authorizations
rule (object type AC) = workflow
If it is workflow you are looking for, then the table is swdsexpr with;
exprtype = '013'
expression = 'AC<rule number>'
version = 9999 if you want the active version.
03-07-2014 2:30 AM
You could check table HRP1001
Object type = TS (Standard Task)
Plan version = 01 Current plan
Object ID - Task number
Related object ID (SCLAS) = AG
This should list down all tasks that have role assigned
03-07-2014 3:47 AM
Hi,
Agent assignment on tasks is stored in HRP1001.
Check table SWWWIAGENT. BUT, I think it only contains agents that actually started processing of a task
08-29-2020 2:21 PM
Hi,
This thread was posted long time ago but in case anyone need some clues.
The table for responsible agent in a specific Workflow item is SWWUSERWI
Thanks and Regards,
Ken