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

Document ID : KB000004471
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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

Resolution:

Currently being reviewed