Clarity PPM

Expand all | Collapse all

Db Table - Auto Start Condition

Jump to Best Answer
  • 1.  Db Table - Auto Start Condition

    Posted 11-26-2018 05:07 AM

    Dear All,

     

    Anybody can help me to provide Db Table name that stores Auto start conditions that we define for clarity processes?



  • 2.  Re: Db Table - Auto Start Condition
    Best Answer

    Posted 11-26-2018 11:25 AM

    Hi Giriraj,

     

    The table you are looking for is odf_filter_expressions:

     

    The following query will give you a list of your start conditions for all active processes:

     

    select ofe.id, bdo.object_name, ofe.object_instance_id, bdp.process_code, ofe.expression
    from odf_filter_expressions ofe, bpm_def_process_versions bdpv, bpm_def_processes bdp, bpm_def_objects bdo
    where object_code = 'BPM_DEF_PROCESS_VERSIONS'
    and bdpv.id = ofe.object_instance_id
    and bdpv.user_status_code = 'BPM_PUS_ACTIVE'
    and bdpv.start_event_code in ('update', 'create' ,'createupdate')
    and bdpv.process_id = bdp.id
    and bdo.src_pk_id= bdpv.id
    and src_table_name = 'BPM_DEF_PROCESS_VERSIONS'
    and bdo.type_code = 'BPM_POT_PRIMARY'
    order by bdo.object_name

     

    I hope this helps.

     

    Jeanne



  • 3.  Re: Db Table - Auto Start Condition

    Posted 11-27-2018 08:42 AM

    Thanks Jeanne for helping out on this.