Index: openacs-4/contrib/packages/simulation/www/siminst/index.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/simulation/www/siminst/Attic/index.tcl,v diff -u -r1.17 -r1.18 --- openacs-4/contrib/packages/simulation/www/siminst/index.tcl 16 Dec 2003 09:58:18 -0000 1.17 +++ openacs-4/contrib/packages/simulation/www/siminst/index.tcl 16 Dec 2003 12:48:31 -0000 1.18 @@ -139,7 +139,7 @@ casting_type { label "Casting Type" } - users { + n_users { label "Users enrolled" } case_start { @@ -172,8 +172,13 @@ ss.enroll_type, ss.casting_type, (select count(*) - from sim_party_sim_map spsm - where spsm.simulation_id = w.workflow_id) as users, + from sim_party_sim_map spsm, + party_approved_member_map pamm, + users u + where spsm.simulation_id = w.workflow_id + and spsm.type = 'auto-enroll' + and spsm.party_id = pamm.party_id + and pamm.member_id = u.user_id) as n_users, to_char(ss.case_start, 'YYYY-MM-DD') as case_start from workflows w, sim_simulations ss,