In Metastorm e-Work 6.6.x
When adding a timed action to an existing map which have folders on that stage, the folders do not get assigned that Timed Action and no entry is made in eWait.
Solution :
I’ve written the attached Store Procedure which runs through all the folders on the selected stage and adds the action where needed to eWait. You can also define what the deadline should be set to.
Variables that needs to be provided:
- @map varchar(100), – the map name
- @stage varchar(100), – stage to which the action was added
- @timedActionName varchar(100) – the name of the timed action that was added
Then the following line should be edited in the Stored procedure to set what the deadline should be. Set the correct map table and field(will maybe update the SP to dynamically to this later):
- SELECT ef.eFolderID,mr.dteDeadline FROM EFOLDER ef,MapTable mr WHERE mr.efolderid=ef.efolderid AND eMapName=@map AND eStageName=@stage
Hope this post will help someone out abit.