To Dos Related Object Instance Information In Database

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Where in the Database can you find the information regarding the To Dos and the relation they have with their associated object instance?

Environment

Any Clarity supported release.

Resolution

SELECT * FROM OBA_ASSOCIATIONS WHERE SRC_OBJECT_ALIAS = 'obaTodos'

This includes information regarding their associated instance, such as the related object type (ASSOC_OBJECT_ALIAS) and related object instance ID (ASSOC_INSTANCE_ID).