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'

Additional Information

- To identify Views:
SELECT v.id, v.name, v.type, v.owner, v.associated_instance_id, v.associated_object_type, v.view_mode, v.view_classifier, u.id AS user_id
FROM odf_ui_views v JOIN cmn_sec_users u ON v.owner = u.id
WHERE v.view_mode = 'UNSAVED' AND v.type = 'projects' AND u.user_name IN ('actual_user_name_here')

- To get the view customizations are stored in cmn_ui_personalizations:
SELECT p.* from cmn_ui_personalizations p
JOIN cmn_sec_users u ON u.id = p.user_id
AND p.component IN ('projects')
AND u.user_name IN ('actual_user_name_here')

- The project blueprint with added attributes are stored in odf_fields table:
SELECT * from odf_fields where section_id in (select id from odf_sections where blueprint_id = '0000000')