Problem Multi valued Parameterized Lookup

Document ID : KB000117782
Last Modified Date : 18/10/2018
Show Technical Document Details
Issue:
DE40581: A MVL (Multi Valued Lookup) field using a parameter construct is not displaying all the saved values 

STEPS TO REPRODUCE 

1. Create Dynamic Lookup. It includes Parameter like as below. 

SELECT 
@SELECT:RES.ID:ID@ 
,@SELECT:RES.FULL_NAME:FULL_NAME@ 
FROM 
SRM_RESOURCES RES 
WHERE 
@FILTER@ 
@BROWSE-ONLY: 
AND ((RES.IS_ACTIVE = 1) AND (@WHERE:PARAM:USER_DEF:INTEGER:N_FLG@ = 1)) :BROWSE-ONLY@ 

2. Create custom object. 
 
a. create attribute. (n_flg) 

b. create attribute. (sugsh02_test_lookup)

c. define View settings. (Layout Create)

d. define View settings. (Layout Edit) 

3. Access custom object list and create instance, and select some active user for multi value lookup field and click on 'Save' button. 

4. Go to the Resource page and make user who is selected by above step to Inactive. 

5. Go to custom_object page and view instance. 

Expected result: Inactive user who was selected before is appeared. 

Actual Result: Inactive user who was selected before is not appeared. The @BROWSE-ONLY@ works when selecting a value, but the DISPLAY for saved values seems to be using the @BROWSE@ logic when it should not. 
Environment:
CA PPM releases prior to CA PPM v15.5
Resolution:
If the query does not have @BROWSE-ONLY@ section, it works as expected to display all the saved values. However, when selecting a value, the user would see all values for selection. This is fixed within CA PPM v15.5. No fix is available prior to CA PPM v15.5 apart form modifying the query so the browse-only is not present.