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.
Release : 15.6.1
Component : CA PPM SAAS STUDIO
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)