Is there a query to identify all object display conditions on our PPM environment?
Article ID: 76794
Updated On:
Products
Clarity PPM On Premise
Issue/Introduction
How can I get the list of object display conditions of our PPM environment?
Environment
Release: 451-101-15.3-Clarity-Creator User License
Component:
Component:
Resolution
The following query will allow you to identify the Display Conditions at DB level:
SELECT exp.object_instance_id, v.object_code, v.caption, v.view_type,
v.link_code, exp.expression, v.partition_code
FROM odf_filter_expressions exp, odf_views v
WHERE exp.object_code = 'ODF_VIEW_CONDITION'
AND exp.OBJECT_INSTANCE_ID = v.id
SELECT exp.object_instance_id, v.object_code, v.caption, v.view_type,
v.link_code, exp.expression, v.partition_code
FROM odf_filter_expressions exp, odf_views v
WHERE exp.object_code = 'ODF_VIEW_CONDITION'
AND exp.OBJECT_INSTANCE_ID = v.id
Feedback
Powered by
