FANDOM


Getting the email templates that are associated with manual activities in a process (aka workflow template)Edit

select p.object_name, pr.r_act_name, r.description, d.object_name
  from dm_process p, dm_process_r pr, dm_relation r, dm_document d
 where p.object_name = <process_name>
   and p.r_object_id = pr.r_object_id
   and pr.r_act_def_id is not NULL
   and r.relation_name = 'dm_bpm_email_template'
   and r.parent_id = pr.r_act_def_id
   and d.r_object_id = r.child_id
order by pr.r_act_name, r.description

Getting the email templates that are associated with events on process levelEdit

select p.object_name, r.description, d.object_name
  from dm_process p, dm_relation r, dm_document d
 where p.object_name = <process_name>
   and r.relation_name = 'dm_bpm_email_template'
   and r.parent_id = p.r_object_id
   and d.r_object_id = r.child_id
order by p.object_name, r.description;


-

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.