Toast Error Message thrown on Modern UX when selecting Parameterized Lookup Values

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Selecting parameterized lookup values is generating an error on the Properties, flyout Details or Timeline layouts.

Steps to Reproduce:

1. Login to Clarity Classic UI.
2. Navigate to Studio and Create a Custom object with ID "z_cust_test"
3. Create a String Attribute with id "z_loc" on the Custom Object.
4. Create 4 - 5 instances of the custom object.
5. Create a Lookup Test1 with the following Query.
   

   SELECT             
   @SELECT:NAME:NAME@,
   @SELECT:z_loc:LOC@          
   FROM   
   ODF_CA_Z_CUST_TEST          
   WHERE  
   @FILTER@

6. Create a Lookup type Custom Attribute on Project Object with ID "z_nm_clt" and Lookup from step 5  "Test1".
7. Create a second lookup Test2 with the following Query.

   SELECT @SELECT:INV.CODE:CODE@,
   @SELECT:INV.NAME:NAME@
   from
   odf_ca_project ocp join inv_investments inv on ocp.id=inv.id
   where 1=1 and
   @FILTER@
   @BROWSE-ONLY:
   AND ocp.z_nm_clt = @WHERE:PARAM:USER_DEF:STRING:OBJ_CODE1@
   and inv.odf_object_code = @WHERE:PARAM:USER_DEF:STRING:OBJ_CODE2@
   :BROWSE-ONLY@

8. Create a Lookup type Custom Attribute on Project Object with ID "z_clt_param" and lookup from step 7 "Test2". Mark this attribute as Value Required. Select obj_code1 = z_nm_clt and obj_code2 = odf_object_code in the parameters section of the attribute.
9. Create a third lookup Test3 with the following query. 

   SELECT @SELECT:OCP.ID:ODF_PK@,
   @SELECT:ocp.obj_status_reporting:STATUS_REPORT@,
   @SELECT:ocp.obj_request_category:REQ_CAT@,
   @SELECT:ocp.obj_request_type:REQ_TYPE@
   FROM
   ODF_CA_PROJECT OCP
   JOIN INV_INVESTMENTS INV on INV.id=OCP.id
   WHERE
   @FILTER@
   @BROWSE-ONLY:
   AND OCP.z_clt_param = @WHERE:PARAM:USER_DEF:STRING:INV_CODE@
   AND INV.ODF_OBJECT_CODE = @WHERE:PARAM:USER_DEF:STRING:OBJ_CODE@
   :BROWSE-ONLY@

10. Create a Lookup type Customer attribute on Project Object with ID "z_clt_det" and lookup from step 9 "Test3". Mark this attribute as Value Required. Select inv_code = z_clt_param and obj_code = odf_object_code
11. Navigate to Modern UX -> Administration -> Blueprints. Create a copy of the project blueprint.
12. Edit the blueprint and add the three attributes to the properties module. Publish the blueprint.
13. Navigate to a project associated to the blueprint from step 12 and start populating the 3 custom attributes.  

Expected Results: No errors should be shown.

Actual Results: Toast message error: API-1013 : Invalid filter string. 

Environment

Clarity PPM 16.3.0

Cause

DE157153

Resolution

DE157153 fixed in 16.3.1 and also backported to 16.3.0 Patch 1