sql code that feeds object view page in Clarity PPM
Article ID: 187227
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'
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'
Feedback
Yes
No
Powered by
