Where are User Assigned Tasks located in the Database and an we review outside of a Process?

Document ID : KB000012654
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Where are User Assigned Tasks located in the Database and is it possible to review task ownership outside of a Process?

Answer:

Tasks are held in the c2opromptuser table.

The Task id is the ROID column and the Title is the PromptTitle in the above table.



The Assignee is a bit more difficult to get to. You will need to parse it out of the UserInfoXML column:

(page)userInfo(/page)(/display)
(cstring)(value)pamadmin(/value)