Using the Attribute Value Protection (AVP) setting of 'Use display conditions and secured subpages to protect attribute values on this list' (full AVP) on the 'Project List' object could cause performance issues. It's recommended if you do not use the 'display conditions' portion of AVP, change your settings to ‘Use only secured subpages to protect attribute values on this list’. This article walks you through how to configure this setting.
Due to the current design, the application does not have the functionality to make this type of configuration change for all affected views. The details for making direct database updates to change the Clarity AVP default configuration setting have been reviewed and approved by our Development Team. Be sure to make a backup of your environment and to test this configuration change in a non-production environment before proceeding to implement it into a production environment.
The below method is provided by our Development Team:
SELECT code AS OBJECT_VIEW,
CASE
WHEN use_display_conds_for_security = 0
THEN 'SECURE SUBPAGES'
WHEN use_display_conds_for_security = 1
THEN 'FULL AVP'
ELSE 'LOWEST'
END AS AVP_SETTING
FROM cmn_grids
WHERE principal_type ='SYSTEM'
AND (USE_DISPLAY_CONDS_FOR_SECURITY=1
OR use_display_conds_for_security =2)
AND (dal_type ='object'
OR dal_type ='system')
AND code IS NOT NULL
SELECT code AS OBJECT_VIEW,
CASE
WHEN use_display_conds_for_security = 0
THEN 'SECURE SUBPAGES'
WHEN use_display_conds_for_security = 1
THEN 'FULL AVP'
ELSE 'LOWEST'
END AS AVP_SETTING
FROM cmn_grids
WHERE principal_type ='USER'
AND (USE_DISPLAY_CONDS_FOR_SECURITY=1
OR use_display_conds_for_security =2)
AND (dal_type ='object'
OR dal_type ='system')
AND code IS NOT NULL
UPDATE cmn_grids
SET use_display_conds_for_security=0
WHERE id IN
(SELECT id
FROM cmn_grids
WHERE principal_type ='SYSTEM'
AND (USE_DISPLAY_CONDS_FOR_SECURITY=1
OR use_display_conds_for_security =2)
AND (dal_type ='object'
OR dal_type ='system')
)
UPDATE cmn_grids
SET use_display_conds_for_security=0
WHERE id IN
(SELECT id
FROM cmn_grids
WHERE principal_type ='USER'
AND (USE_DISPLAY_CONDS_FOR_SECURITY=1
OR use_display_conds_for_security =2)
AND (dal_type ='object'
OR dal_type ='system')
)
In Clarity 14.3 an enhancement was implemented for setting the default, stock configuration as noted in this article to prevent performance issues on new deployments. For existing customer deployments after an upgrade to this release or higher, the AVP setting remains set to the same option in use before the upgrade. On Premise customers may elect to use the identified workaround to change this setting for their existing views