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