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

Document ID : KB000076794
Last Modified Date : 09/04/2018
Show Technical Document Details
Question:
How can I get the list of object display conditions of our PPM environment?
Answer:
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