Index: openacs-4/packages/workflow/tcl/action-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/action-procs-postgresql.xql,v diff -u -r1.11 -r1.12 --- openacs-4/packages/workflow/tcl/action-procs-postgresql.xql 11 Mar 2004 16:49:37 -0000 1.11 +++ openacs-4/packages/workflow/tcl/action-procs-postgresql.xql 23 Nov 2017 14:43:09 -0000 1.12 @@ -34,32 +34,12 @@ a.description, a.description_mime_type, extract (days from a.timeout) * 86400 + extract (hours from a.timeout) * 3600 + - extract (minutes from a.timeout) * 60 + extract (seconds from a.timeout) as timeout_seconds + extract (minutes from a.timeout) * 60 + extract (seconds from a.timeout) as timeout_seconds from workflow_actions a left outer join workflow_fsm_actions fa on (a.action_id = fa.action_id) where a.workflow_id = :workflow_id order by a.sort_order - - - - select coalesce(max(sort_order),0) + 1 - from workflow_action_callbacks - where action_id = :action_id - - - - - insert into workflow_action_allowed_roles - select :action_id, - (select role_id - from workflow_roles - where workflow_id = :workflow_id - and short_name = :allowed_role) as role_id - - - -