Virtual attribute does not show data

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

In a case you create new 2 virtual attributes on investment sub object where each is based on different parent object but with the same parent's object attribute id. It does show values only for one

Steps to Reproduce:

1. Create virtual attribute X2 on the object virtual attribute should be based on project object attribute Project Type
2. Create virtual attribute X1 on the object virtual attribute should be based on Idea object attribute Idea Type
3. Configure the sub-object as module on the idea, project and hierarchy blueprint
4. Map an idea instance with Idea blueprint and passed value for idea type field on idea instance
5. Map a project instance with project blueprint and passed value for project type field on project instance
6. Create instances for the sub-object on idea and project
7. Create a Hierarchy and import the idea and project instances from step 4&5
8. Navigate to Sub object tab on Hierarchy
9. Navigate to sub object on Project
10. Navigate to sub object on Idea

Expected Results: 

• Hierarchy - The values for virtual attributes are populated for idea and project instances
• Project - The values for virtual attributes are available on sub object
• Idea - The values for virtual attributes are available on sub object

Actual Results:

• Hierarchy - The values for virtual attributes are available only for idea. The value for project based attribute also displays the value same as idea based attribute
• Project - The values for virtual attributes are blank
• Idea - The values for virtual attributes are available but the project based attribute also displays the value same as idea based attribute

Cause

This is caused by DE78599

Resolution

As of Clarity 16.2.2 a feature toggle was introduced to handle these scenarios where an attribute derives from multiple parents with the same column name.

In order to enable this feature run the following command on the Clarity server:

admin toggle-feature APPLY_DB_ALIAS_FOR_VIRTUAL_ATTRS_DE78599 1