Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
rtm77

Awaiting Email Confirmation
Registered:
Posts: 2
Reply with quote  #1 
Using Metastorm 7.6

I have a need to remove cases that have been closed for more than 3 years.  I expect the cases are in the Archive stage.  

Is there some built-in metastorm process that I should use?

Or do you need to manage the data via your own SQL?
For example remove from efolder, eevent, eattachment, elog and remove from the case table. Is there any other metastorm tables that could/should be updated? 

I am not sure if there would be anything in ewait if it is in archive stage?

Is there any known impact of doing this while Metastorm is running?

Is there documentation that describes the tables and there uses, etc?

Thanks
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #2 
You need top run your own SQL. There is a complete answer here:
http://metastorm.processmapping.com.au/post?id=4867003

__________________
Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
0
rtm77

Awaiting Email Confirmation
Registered:
Posts: 2
Reply with quote  #3 

Thanks, for the quick response. It was very helpful!

0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!