Clarity Modern UX Views stored in the database

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Can you provide the Database Table information on Views created in Clarity PPM Modern UX  for the following objects - (Tasks, Risks, Issues, Change Request) ?

Environment

Release : All Releases

Component : CA PPM APPLICATION

Resolution

The Clarity PPM Modern UX Views are stored in the 'ODF_UI_VIEWS' table.

For example to retrieve the record of a Clarity PPM View called 'AAA'  you can execute the following Sql statement;

select * from odf_ui_views where name = 'AAA'