Custom object created on Investment object is not filtering on Status report page
Steps to Reproduce:
- Login to Clarity with administrative access
- Navigate to Administration --> Data Administration--> Lookup-->
- 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@
- Now navigate back to Administration --> Studio --> Objects
- Create a custom lookup attribute and associate the lookup created in above step and enable for API access
- Navigate to project grid and add the custom lookup attribute and fill the values
- Now navigate to Status Reports menu and add the custom lookup attribute created in the grid
- 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.