Clarity PPM

Expand all | Collapse all

Query to extract Process start condition

Jump to Best Answer
  • 1.  Query to extract Process start condition

    Posted 03-03-2016 12:07 PM

    what table is storing the start condition defined in an auto-start process?

     

    I would like to list these conditions but after a quick look to bpm_def tables and relations i couldn't see these conditions.

     

    Thanks



  • 2.  Re: Query to extract Process start condition

    Posted 03-03-2016 02:41 PM

    Try

    ODF_FILTER_EXPRESSIONS



  • 3.  Re: Query to extract Process start condition
    Best Answer

    Posted 03-03-2016 03:52 PM

    Hi Daniel,

     

    Martti got the table right.

     

    However, here is a query that should get you the information you want.  Just substitute the name of the process you want or delete the clause in the Where part of the query that gives the process name(s) in order to see all start conditions.

     

     

    select bdp.id, cc.name, bdp.process_code, ofe.expression from bpm_def_processes bdp, cmn_captions_nls cc,

     

      bpm_def_process_versions bdpv, odf_filter_expressions ofe

     

    where lower(cc.name) in ('add new pm as cm', 'cost type sync')

     

    AND cc.table_name = 'BPM_DEF_PROCESSES'

     

    AND bdp.id = cc.pk_id

     

    AND cc.language_code = 'en'

     

    AND bdpv.process_id = bdp.id

     

    AND ofe.object_code = 'BPM_DEF_PROCESS_VERSIONS'

     

    AND ofe.object_instance_id = bdpv.id

     

    Sincerely yours,

     

    Jeanne Gaskill

    Senior Support Engineer

    CA PPM (aka Clarity)