search cancel

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

book

Article ID: 258380

calendar_today

Updated On:

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:[email protected],
             @SELECT:PORTF.NAME:[email protected],
                         @SELECT:PORTF.LAST_UPDATED_DATE:[email protected]
      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  @[email protected]
  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

This is logged as DE68205 and currently in review with engineering team