Resource Finder portlet displays no items when a 'Multi Valued lookup - number' attribute is added to the selected column

book

Article ID: 4471

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

If you create an attribute of type 'Multi Valued Lookup - Number' on the Resource object and add it to the Selected Columns of the Resource Finder portlet, you will get the following error in the app-ca.log and no entries are shown in the portlet list regardless of the filtering:

Caused by:java.sql.SQLSyntaxErrorException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "ODF_CA_RESOURCE"."Z_MULTI_VALUED_ATTR".invalid identifier.

Steps to Reproduce:

1. Create a 'Multi Valued Lookup - Number' in the Resource object.

2. Navigate to Home -> Resource Management -> Resource Finder portlet.

3. Click on the Options icon -> Configure -> List Column Layout, and add the attribute created in step one to the 'Selected Columns' section.  Click the Save and Return button.

Expected Result: Data in the Resource Finder portlet displayed including the newly created attribute.

Actual Result: No data displayed in the Resource Finder portlet.

Cause

Caused by CLRT-79696

Environment

Release: 451-101-15.1-Clarity-Creator User License
Component:

Resolution

Currently being reviewed