#2159 PackIn is linking workflow start node wrongly

[Teo Sarca]

PackIn is linking workflow start node wrongly, to a node with the same name but from other workflow.

To prevent this, i will fix the WorkflowElementHandler class but I would like also to add following database contraint:

CREATE UNIQUE INDEX ad_wf_node_workflownode ON ad_wf_node (ad_workflow_id, ad_wf_node_id);
ALTER TABLE AD_Workflow DROP CONSTRAINT adwfnode_adworkflow;
ALTER TABLE AD_Workflow ADD CONSTRAINT adwfnode_adworkflow FOREIGN KEY (ad_wf_node_id, ad_workflow_id)
REFERENCES ad_wf_node (ad_wf_node_id, ad_workflow_id);

What do you think ?

Best regards,
Teo Sarca

[Teo Sarca]

Revision: 10513
http://adempiere.svn.sourceforge.net/adempiere/?rev=10513&view=rev
Author: teo_sarca
Date: 2009-10-06 05:24:43 +0000 (Tue, 06 Oct 2009)

Log Message:
-----------
BF [ 2873271 ] PackIn is linking workflow start node wrongly
https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2873271&group_id=176962

Modified Paths:
--------------
trunk/base/src/org/adempiere/pipo/handler/WorkflowElementHandler.java

[Carlos Ruiz]

xref about the foreign keys:
https://sourceforge.net/projects/adempiere/forums/forum/610548/topic/3418039/index/page/1

[SourceForge Robot]

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).