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

Article Id: 76794

Status: Published

Updated On: 15-10-2020 08:01

Products:

Clarity PPM On Premise , Clarity PPM SaaS , 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