Lookup values on grandchild or child object, restrict based on parent or grandparent in the Modern UI

Products

• Clarity PPM SaaS

Issue/Introduction

How can a lookup  on a grandchild reference an attribute value on the parent or grandparent in Modern UX?

Environment

Release : 16.1.1

Resolution

Here is a lookup example of referencing the grandparent object as a lookup

 

SELECT @SELECT:id:prj_id@ FROM INV_INVESTMENTS
WHERE @FILTER@ AND    
(@WHERE:PARAM:USER_DEF:STRING:PRJ_ID@ IS NULL OR @WHERE:PARAM:USER_DEF:STRING:PRJ_ID@ = id)

 

Our attribute on the grandchild object

 

 

and here we can see the project id before the grandchild object is created