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

book

Article ID: 143076

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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

Environment

Release : All Supported Releases

Component : CA PPM APPLICATION

Resolution

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
bdp.id  process_id,
ccn.name 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 bdp.id =  bdpv.process_id
 inner join cmn_captions_nls ccn on  bdp.id = ccn.pk_id
   and ccn.table_name = 'BPM_DEF_PROCESSES'
   and ccn.language_code = 'en'
 inner join bpm_def_stages bdsa on bdpv.id = 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