ToDo records are missing from dwh_todo_v and DWH_INV_TODO

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Not all records in the ToDo list in the UI are showing in the Clarity or DWH tables/view below

Clarity: dwh_todo_v 

DWH: DWH_INV_TODO

Cause

DWH_INV_TODO and dwh_todo_v are not populated anymore with the latest data and will have records missing from these table/views. 

Resolution

The tables/views to be used to query the ToDo list are 

Clarity: oba_todos 

DWH: dwh_oba_todo_v (assoc_parent_key is the relation to the investment key)