Risk and Tasks association Reference

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

How can we query the Tasks which are mapped to Risk in Clarity. The Associated Tasks in the Risk page shows the Tasks which are linked with Risk. We need to see this data in the database. 

Environment

Release : 16.0.2

Component : Risks and Tasks

Resolution

The table ITL_OBJECT_ASSOCIATIONS holds the mapping information of Risk and Associated tasks.

Example:

SELECT PK_ID FROM ITL_OBJECT_ASSOCIATIONS WHERE OBJECT_TYPE='Risk' AND OBJECT_ID=(Your Risk internal ID)

The pk_id column from the above table holds the associated task internal id value

SELECT * FROM PRTASK WHERE PRID = (pk_id from above query) 

Additional Information

Project Tasks - Associated Risks/Issues