Index: openacs-4/packages/workflow/tcl/workflow-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/workflow/tcl/workflow-procs.xql 29 Oct 2003 10:47:12 -0000 1.7 +++ openacs-4/packages/workflow/tcl/workflow-procs.xql 23 Nov 2017 12:38:07 -0000 1.8 @@ -1,6 +1,34 @@ + + + select w.workflow_id, + w.short_name, + w.pretty_name, + w.object_id, + w.package_key, + w.object_type, + w.description, + w.description_mime_type, + a.short_name as initial_action, + a.action_id as initial_action_id + from workflows w left outer join + workflow_actions a on (a.workflow_id = w.workflow_id + and a.parent_action_id is null + and a.trigger_type = 'init') + where w.workflow_id = :workflow_id + + + + + + select coalesce(max(sort_order),0) + 1 + from workflow_callbacks + where workflow_id = :workflow_id + + + select workflow_id