Query to extract Process start condition

[Daniel Perez]

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

[Deactivated User]

Try

ODF_FILTER_EXPRESSIONS

[Jeanne Gaskill]

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)