How to get Workflow Activity List in Sequence

AKSHAY007
AKSHAY007
edited September 18, 2017 in Documentum #1

Hi Experts ,

I  wart workflow activities name in sequence , i m using below Query but not getting Activity names in sequence, pls suggest how can i get workflow activity names in sequence

Query :- select p.r_object_id, p.object_name, a.object_name as act_name, p.r_link_src_act, p.r_link_dest_act from dm_process p , dm_activity a where p.r_act_def_id  = a.r_object_id AND p.object_name = 'WF-EMPLOYEE-RECORD-APPROVAL' AND a.exec_method_id = '0000000000000000' order by i_position desc enable (ROW_BASED) ;

Help appritiated,

Regards,

Akshay Sonawane

Comments

  • DCTM_Guru
    DCTM_Guru
    edited September 15, 2017 #2

    Assuming you created the activities in sequence, then try ordering r_link_src.  Keep in mind, sequencing doesnt really apply when you have decision branches.

  • AKSHAY007
    AKSHAY007
    edited September 18, 2017 #3

    Thanks for your prompt reply ..

Categories