Index: openacs-4/packages/simulation/lib/sim-template-roles.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/simulation/lib/sim-template-roles.tcl,v diff -u -r1.14.2.3 -r1.14.2.4 --- openacs-4/packages/simulation/lib/sim-template-roles.tcl 19 Dec 2006 15:34:02 -0000 1.14.2.3 +++ openacs-4/packages/simulation/lib/sim-template-roles.tcl 15 Feb 2007 14:01:31 -0000 1.14.2.4 @@ -96,7 +96,7 @@ from workflow_roles wr, sim_roles sr left join cr_items ci on (sr.character_id = ci.item_id) - join sim_charactersx sc on (ci.item_id = sc.item_id + left join sim_charactersx sc on (ci.item_id = sc.item_id and ci.live_revision = sc.object_id) where wr.workflow_id = :workflow_id and wr.role_id = sr.role_id