postgresql7.2 select c.case_id, c.workflow_id, c.object_id, s.state_id, s.short_name as state_short_name, s.pretty_name as pretty_state, s.hide_fields as state_hide_fields from workflow_cases c, workflow_case_fsm cfsm left outer join workflow_fsm_states s on (s.state_id = cfsm.current_state) where c.case_id = :case_id and cfsm.case_id = c.case_id select m.party_id, p.email, acs_object__name(m.party_id) as name from workflow_case_role_party_map m, parties p where m.case_id = :case_id and m.role_id = :role_id and p.party_id = m.party_id select l.entry_id, l.case_id, l.action_id, a.short_name as action_short_name, a.pretty_past_tense as action_pretty_past_tense, io.creation_user, iou.first_names as user_first_names, iou.last_name as user_last_name, iou.email as user_email, io.creation_date, to_char(io.creation_date, 'fmMM/DDfm/YYYY') as creation_date_pretty, r.content as comment_string, r.mime_type as comment_mime_type, d.key, d.value from workflow_case_log l join workflow_actions a using (action_id) join cr_items i on (i.item_id = l.entry_id) join acs_objects io on (io.object_id = i.item_id) join cc_users iou on (iou.user_id = io.creation_user) join cr_revisions r on (r.revision_id = i.live_revision) left outer join workflow_case_log_data d using (entry_id) where l.case_id = :case_id order by creation_date select a.action_id, extract(seconds from a.timeout) as timeout_seconds from workflow_cases c, workflow_actions a where c.case_id = :case_id and a.workflow_id = c.workflow_id and not exists (select 1 from workflow_initial_action wia where wia.workflow_id = c.workflow_id and wia.action_id = a.action_id) and (a.always_enabled_p = 't' or exists (select 1 from workflow_case_fsm cfsm, workflow_fsm_action_en_in_st waeis where cfsm.case_id = c.case_id and waeis.state_id = cfsm.current_state and waeis.action_id = a.action_id)) order by a.sort_order select case_id, action_id from workflow_case_enabled_actions where execution_time <= current_timestamp and enabled_state = 'enabled' select acs_object__name(:object_id) as name select distinct acs_object__name(p.party_id) || ' (' || p.email || ')' as label, p.party_id from [ad_decode $subquery "" "cc_users" $subquery] p where upper(coalesce(acs_object__name(p.party_id) || ' ', '') || p.email) like upper('%'||:value||'%') order by label select acs_object__name(p.party_id) || ' (' || p.email || ')' as label, p.party_id from parties p where p.party_id in ([join $party_id_list ", "]) order by label select workflow_case_pkg__delete(:case_id) update workflow_case_enabled_actions set enabled_state = 'completed', executed_date = current_timestamp where case_id = :case_id and action_id = :action_id and enabled_state = 'enabled' insert into workflow_case_enabled_actions (enabled_action_id, case_id, action_id, enabled_state, execution_time) select :enabled_action_id, :case_id, a.action_id, 'enabled', current_timestamp + a.timeout from workflow_actions a where a.action_id = :action_id