Thursday, March 4, 2010


SQL - Metastorm

What ever tables come with prefix ‘e’ in table name inside Metastorm database are system tables. Don’t play with that tables, it may corrupt Metastorm suite.
Some of them we are going to discuss here.
Efolderid: which is important, based on this id the Metastorm is connecting tables and relationships.So we can call it like a control point
Ealert : this table is used to find who all are in watch list and who are in to do list,
inside this table there is a column named ealerttype,
If ealerttype=~, then it is watch list
=blank, then it is in to do list
=!, Metastorm don’t know which stage it is(that’s why exclamation, just wondering)
Efolder: it is treated as master control.
estage: indicates whether the process is in which stage right now.
Note: After publishing your procedure, you just explore through these tables. You can realize directly what actually happens inside and what the relations between these tables are and how Metastorm is using these tables for smooth functioning



AddThis Social Bookmark Button

0 comments: