Virtual Attribute not Populating on Sub-Sub Object

book

Article ID: 197578

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

A dynamic lookup created for the subobject of the project works as expected on that subobject. However, making it a virtual attribute on a sub-sub object does not work. The value always shows up blank on the virtual attribute.

Environment

Release : 15.6.1

Component : CA PPM SAAS STUDIO

Resolution

The NSQL query being used by the lookup needs to be modified to include a null parameter. Otherwise it will only work when both the project internal ID and the subobject internal ID are the same, which is not likely to happen very often. 

For example, it would need to be changed from this: 

AND INV.ID = (@WHERE:PARAM:USER_DEF:INTEGER:[email protected]

to this: 

AND (@WHERE:PARAM:USER_DEF:INTEGER:[email protected] IS NULL OR 
@WHERE:PARAM:USER_DEF:INTEGER:[email protected] = INV.ID)