Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

 
Metastorm BPM forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
levysanjose

Member
Registered:
Posts: 42
Reply with quote  #1 
Hi,

I would to have a table that lists all the actions in my project and the roles assigned in available to roles property. What tables do I need to query? Thanks.
0
bigfootger

Veteran
Registered:
Posts: 139
Reply with quote  #2 
Hi,

No 100% sure what you are after exactely. To get all the actions for your process/map you can query the table eAction.

SELECT eActionName, eCaption FROM [Metastorm].[dbo].[eAction]
where eMapName = 'YOURPROCESS'


To query all the roles available in your process/map use the following:

SELECT eRoleName, eProcedureName WHERE eProcedureName ='YOURPROCESS'

I hope this helps.

Best regards
Sascha


__________________
Metastorm BPM Remote Expert Help & Web Consultations - http://connect.convedo.com/free-1-hour-web-consultation
0
Jerome

Avatar / Picture

Guru
Registered:
Posts: 5,507
Reply with quote  #3 
Well, it is not as easy as that. There are two problems. The first is that the role list for each action is in the eAction table, but as a comma-delimited list for each action. Not easy to manage unless that would work for you (unlikely).

The second is that calculated roles are in this field as the calculation, not the actual role name. The results are rarely readable.

I recommend looking at our Procedure Documentation tool which can give you a matrix of actions and roles for each process, and a matrix for the alert lists as well.

Details: http://www.processmapping.com.au/ProcedureDocumenter.htm
Demo: http://www.processmapping.com.au/demos/ProcDoc.html
Output (better in IE): http://www.processmapping.com.au/download/UserDetails/UserDetails20.html
Download: http://www.processmapping.com.au/download/Proc%20Doc%20Setup.zip

__________________
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
Previous Topic | Next Topic
Print
Reply

Quick Navigation:


Create your own forum with Website Toolbox!