Export to Excel (data only) when using the default attribute value protection setting "Use display conditions and secured subpages to protect attribute values on this list" along with display conditions on views will fail to export data for all rows even if some meet the display condition and are shown in the UI.
Steps to Recreate
Expected Results: For all data visible in the UI to export.
Actual Result: No data exports for column with condition.
Change the attribute value protection to "Use only secured subpages to protect attribute values on this list" or "Display all attribute values on this list" and republish views. If children or grandchildren subpages are involved - be sure and change this setting from the grandchildren all the way up to the parent and republish all views. Note that the publish will eliminate any user changes in their own personal views.
The following query will help you identify which views in the system have display conditions on them:
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
Resolved in Clarity 12.1.1
Resolved in Clarity 12.0.6 Generic Patch. Reference TEC522707.
Keywords: CLARITYKB, CLRT-54964, clarity12resolved, clarity1211resolved, e2e, avp, blank columns, Export to Excel, AVP, Attribute Value Protection, secured sub pages.
Release: ESPCLA99000-12.1-Clarity-Extended Support Plus