I'm looking to find all the related tables for Worklist approval tasks in PAM 4.3 HF01, does anyone has this list?
The best way to do this is via the Operations tab in PAM. There is a choice of tasks there and a drop down on the top right to show "All Tasks". From there you can sort based on any of the columns including Assignee and then right click on a task to transfer it. You can even multi-select tasks and then use the buttons in the toolbar to perform functions on all of the selected tasks.
Tasks are stored as part of the process definition, primarily under the c2oRuntimeObjects table and the c2opromptuser table, but they are not easily accessible directly in the database.
Can you please elaborate on what you are attempting to do and what information you are looking for?
Was trying to find a better way for looking up a task or multiple tasks from the tasks list pages and transfer the ownership to another user for approvals.
There could be bunch of workflow tasks that needs to be transferred to other groups or individuals on the fly, where an Admin routes them appropriately. It becomes slightly cumbersome to lookup for rerouting those approval tasks manually and especially if there are tons of tasks across several pages.
Vishnu, this is not currently possible. You might be able to create a separate web page that handles this using API calls.
Please jump over to the IDEAs area and request this as an enhancement.
Retrieving data ...