Portlets using the Browse feature for filters are not working

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Portlets using the Browse feature for filters are not working. It only works for Autosuggest.

STEPS TO REPRODUCE:

1. Create Query with following NSQL

SELECT   @SELECT:DIM:USER_DEF:IMPLIED:Project:R.ID:DIMID@,

     @SELECT:DIM_PROP:USER_DEF:IMPLIED:Project:I.NAME:Proj_Name@,

     @SELECT:DIM_PROP:USER_DEF:IMPLIED:Project:I.Code:Proj_Code@,  

     @SELECT:DIM_PROP:USER_DEF:IMPLIED:Project:MR.FULL_NAME:MANAGER@,

     @SELECT:DIM_PROP:USER_DEF:IMPLIED:Project:MR.ID:MANAGER_FILTER@

FROM              SRM_PROJECTS R,

     SRM_RESOURCES MR,

     CMN_SEC_USERS U,

INV_INVESTMENTS I

WHERE    1=1

AND      U.ID = MR.USER_ID

AND      I.MANAGER_ID = MR.USER_ID

AND  R.ID = I.ID

AND      @FILTER@

2. Go to Query > Attributes >  select the attribute 'manager_filter' 

Set the Lookup = 'Active Resources Browse'

Click Save.

3. Create a  portlet based on the query created.

4.   Configure the portlet > List Filter Section >  

properties icon for 'manager_filter'   

Display Type = Browse

5. Use the portlet  and filter by 

a. Autosuggest

b. Browse Icon

Expected:  Results should be returned, as Autosuggest selection.

Actual: All results are returned.

It only works for Autosuggest.

Resolution

This is being reviewed and tracked as DE78215