Custom attribute on Investment Object doesn't filter on Status Report Page

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Custom object created on Investment object is not filtering on Status report page

Steps to Reproduce: 

1. Login to Clarity with administrative access
2. Navigate to Administration --> Data Administration--> Lookup-->
3. Create a lookup with below sample code 
   
   • SELECT @SELECT:PORTF.CODE:CODE@,
            @SELECT:PORTF.NAME:NAME@,
                        @SELECT:PORTF.LAST_UPDATED_DATE:LAST_UPDATED_DATE@
     from
     (select PFM.CODE,
             PFM.NAME,
                                    PFM.LAST_UPDATED_DATE
     FROM    PFM_PORTFOLIOS PFM
     WHERE   PFM.IS_ACTIVE = 1
     UNION
     select '0' AS CODE,
            'Ingen tilknytning' AS NAME,
                        to_date('1990-01-01', 'YYYY-MM-DD') AS LAST_UPDATED_DATE
     FROM   PFM_PORTFOLIOS PFM) PORTF
     WHERE  @FILTER@
4. Now navigate back to Administration --> Studio --> Objects
5. Create a custom lookup attribute and associate the lookup created in above step and enable for API access 
6. Navigate to project grid and add the custom lookup attribute and fill the values 
7. Now navigate to Status Reports menu and add the custom lookup attribute created in the grid 
8. Filter for the newly added attribute on the status report grid 

Expected Results: The status report grid should be able to filter on the custom attribute created on investment object

Actual Results: The filter on custom attribute lookup created on investment object doesn't fetch any results. 

Environment

Release : 16.x

Cause

DE68205

Resolution

DE68205 is fixed in upcoming release (16.1.1)