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.

Check Stage Timed Actions

written by Arné

After my last post I got a few mails asking me how to reset the Auto Increment ID, or how to set the next ID to a certain value.

Well, here you go:

1. Open up SQL Enterprise/SQL Server Manager
2. Open the relevant database
3. Right click on the relevant table and choose ‘Modify’
4. Select the auto increment / identity column
5. Find the Identification Specification option and expand
   1. Now you can change the Identity seed to the desired value(remember to make it more than the MAX of that column of the current data)

written by Arné