This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Doreen,
Sarah Stewart here. I saw your post on the Yahoo Group about needing to mass reassign.
Try this:
Update wfassignment set assigncode = ‘NewPersonId” where assigncode = ‘OldPersonId’ and assignstatus = ‘ ACTIVE’
NewPersonId is the personid of the employee you want to get the 300 assignments
OldPersonId is the personid of the employee that is leaving.
Hope this helps,
Sarah