Is there a query to identify all object display conditions on our PPM environment?

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:

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