Completion of Workflow Steps whose performers have been deleted

I want the Completion of Workflow Steps whose performers have been deleted (left organization).Should I use a SQL Update query to accomplish that or I should take Livelink Builder help. Is there any function available for that in some module?

Find more posts tagged with

Comments

unknown_user3

anyone to help me please

Donna Nalls

Hello Minu,Although it would probably work, I hesitate to tell you that you can use SQL to accomplish updating the wsubworktask table directly with a new subworktask_performerid. You can certainly give that a try in a test environment and move forward with it if you feel comfortable doing so.If you have a look at the WEBWORK.StepReassignSave Request Handler, you will see that there are several updates that occur besides the task update; thus, my concern for telling you to do this operation directly in the subworktask table.If you want to modify one workflow task at a time, you could use a LiveReport to get a list of your tasks that need to be re-assigned. Then, as one of the columns in the LiveReport, you could embed the url that would invoke the work.stepreassignsave request handler, passing in the appropriate arguments and nextUrl parameter to re-run the LiveReport at the completion of the update. This method would be feasible if you are processing only a few workflow re-assignments at one time. After each one completed, your report would re-run and the list should get smaller by one row each time.The other option is to write a custom request handler and interface by orphaning the WEBWORK.StepReassignSave Request Handler into a custom module -- give it a new fFuncPrefix and/or object name....then modify it according to your needs to loop through all of the workflow tasks that you would like to reassign.The advantage of using your own request handler would be the option of sending out email notification to any user that has received a reassigned task....just a nice bell/whistle that will make your users love you (or hate you, as the case may be)... ;o)I hope all of that made sense - just one person's opinion.Lots of good luck,Donna

Donna Nalls

Hi Minu,My apologies - i think i mis-read your original post...you want to auto-complete the workflow steps of deleted users and not just re-assign them, yes?If that is the case, then you should definitely use a custom interface to do so......See the $WFMAIN.WFAgentScripts.SendOnEngineStep to grab some code for automatically sending workflow steps on.....you will just have to write your interface for viewing and selecting the steps you want to send on....Good luck,Donna

unknown_user3

Thanks donna for your valuable thoughts. I shall get back to you after trying your thoughts.Thanks very much.