Where to find Task AssignedTo Value in DB?

Sandra_Popovic-Ovcina_(intato017_-_(deleted))

We use Livelink 9.5 version now.We were using a 9.2 version for development. Everything went fine when migrating to 9.5 except for a SQL script which selects, inter alia, AssigneTo value from DTree table. It used to be the same as (User)ID value from KUAF table, but now the values are only -1, 0, 1, or NULL.Could you please tell me where AssignedTo value is stored now?Thank you in advance,Sandra Popovic-Ovcina

Donna Nalls

Hi Sandra,Beginning with Livelink 9.5, there is a new table named Assignees -- joins with dtree.dataid on dataid column and kuaf.id on the assignedto column.It appears that Open Text began development on multiple assignees for tasks, but did not implement the code in a production release...one of the additions for this enhancement was the assignees table.Here are some developer's notes that i found in the Task Ospace indicating what the values in dtree.assignedto now signify:// Also, determine what DTree.AssignedTo should be --// 0 means unassigned, 1 or -1 means assigned.// This value must change when assignment changes in order// for task notification to work.Best,Donna