BROWSE-ONLY lookup does not work if it is using a parameter construct

book

Article ID: 105830

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

BROWSE-ONLY of dynamic lookup does not work

STEPS TO REPRODUCE 

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

SELECT 
@SELECT:RES.ID:[email protected] 
,@SELECT:RES.FULL_NAME:[email protected] 
FROM 
SRM_RESOURCES RES 
WHERE 
@[email protected] 
@BROWSE-ONLY: 
AND ((RES.IS_ACTIVE = 1) AND (@WHERE:PARAM:USER_DEF:INTEGER:[email protected] = 1)) 
:[email protected] 

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 save. 
4. Go to 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 @[email protected] works when selecting a value, but the DISPLAY for saved values seems to be using the @[email protected] logic when it should not.          

The field DISPLAY VALUE works as expected with the following query - BUT it does not have the dependent parameter construct at all
SELECT 
@SELECT:RES.ID:[email protected] 
,@SELECT:RES.FULL_NAME:[email protected] 
FROM 
SRM_RESOURCES RES 
WHERE 
@[email protected] 
@BROWSE-ONLY: 
AND RES.IS_ACTIVE = 1 
:[email protected] 

If the query does not have @[email protected] section, it works as expected to display all the saved values.  But then when selecting a value, the user would see all values for selection.

Cause

DE40581

Environment

PPM15.3
PPM15.4

Resolution

Fixed in Clarity PPM 15.5