Index: openacs-4/packages/workflow/tcl/state-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/state-procs.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/workflow/tcl/state-procs.xql 3 Feb 2003 12:23:01 -0000 1.2 +++ openacs-4/packages/workflow/tcl/state-procs.xql 12 Feb 2003 14:23:15 -0000 1.3 @@ -49,4 +49,25 @@ + + + select state_id, + sort_order, + short_name, + pretty_name, + hide_fields + from workflow_fsm_states + where workflow_id = :workflow_id + order by sort_order + + + + + + select workflow_id + from workflow_fsm_states + where state_id = :state_id + + +