Is there a way to Query / Export a list of Processes in Clarity?
search cancel

Is there a way to Query / Export a list of Processes in Clarity?


Article ID: 143076


Updated On:


Clarity PPM On Premise


Is there a way to get Process Names, descriptions, and other values out of Clarity and into a spreadsheet? 


Release : All Supported Releases



1. Here's a query that will pull the ID, Name, description, status, and mode.

  • Status = Indicates whether the process has been validated 
  • Mode = Indicates whether process is in draft, active, on hold 

select  process_id, process_name,
ccn.description Description,
bdpv.user_status_code Process_Mode,
bdpv.Internal_Status_Code Status
from bpm_def_processes  bdp
 inner join bpm_def_process_versions bdpv on =  bdpv.process_id
 inner join cmn_captions_nls ccn on = ccn.pk_id
   and ccn.table_name = 'BPM_DEF_PROCESSES'
   and ccn.language_code = 'en'
 inner join bpm_def_stages bdsa on = bdsa.process_version_id

2. The data can then be copied into a spreadsheet from the query output. 

3. See also Clarity PPM Advanced Reporting and Database Schema Index for more assistance if additional fields are needed or a different query is needed. 

Additional Information


Here's a few communities posts on the topic of some process queries, searing in communities may provide other additional help with queries

See KB 141061 - How to search for known Clarity PPM Issues using Self Service