Unable to get the associated Project name and Task details from TODOs

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We see that there are database views/tables related to the "To Dos" of Clarity PPM as below:

• odf_ca_oba_todo,
• odf_oba_todo_v2,
• prtodo,
• odf_ca_todo,
• OBA_TODOS,
• odf_ca_oba_todo,
• odf_todo_v2

However, we want to map a given "To Do" in the DB with its parent Task and Project. We cannot find a table which provides this mapping.

Environment

Version: 16.0.0

Resolution

There is a table called "oba_associations" which maps the "To Dos" to their parent Tasks. This table can be used.

Additional Information

More Information about ToDo DB tables: https://knowledge.broadcom.com/external/article?articleId=250038