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, 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 = 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 =
    and bdo.src_pk_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.



  • 3.  Re: Db Table - Auto Start Condition

    Posted 11-27-2018 08:42 AM

    Thanks Jeanne for helping out on this.