ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

sql code that feeds object view page in Clarity PPM

book

Article ID: 187227

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Looking for the underlying sql code (or tables/views) that populate the object view page (IE Project Properties)

Environment

Release : All Supported Releases

Component : CA PPM SAAS APPLICATION

Resolution

Query that can help:

select v.code, v.view_type, v.principal_type, v.principal_id, v.view_subtype, v.partition_code, va.widget_type, va.label, va.section_id, va.xpath_expression
from odf_view_attributes va, odf_views v
where v.id = va.view_id
-- and va.attribute_code = '$ATTRIBUTE_CODE'
and v.object_code = 'project'
and v.view_type = 'property'