divya_p02 - Monday, June 13, 2011 7:00 AM:
Hi All,
How can i get the predecessors and successors of an Activity in Workflow. Is it stored somewhere in database directly. Kindly give some references for the same
Eg : Workflow having 4 Acitvities P1, P2 , P3 , P4
P1 : start Acitivity
P2 : Predecessor =P1 and successor =P3
P3 : Predecessor =P2 and successsor =P4
P4- Predecessor=P3 and Successor =(No Successor as it is last acitivyt)
In ARAS how is this relation getting stored. Kindly give reference of the tables where this information is getting stored
Regards,
Divya
Ronan - Monday, June 13, 2011 9:24 AM:
Hi,
Innovator stores Workflow paths information in "Workflow Map Path" objects. The source_id indicates the predecessor of the transition, the related_id indicates the successor. Based on this you can craft a query looking for the id of the successor or the predecessor of an activity.
Open the following query in Nash to see for example what the ECR Workflow Map looks like. (see here for a primer on Nash)
<AML>
<Item type="Workflow Map" action="get" levels="2">
<name>ECR</name>
</Item>
</AML>
?
Ronan Jouchet - PLM Consultant, Processia Solutions
