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.
Caused by CLRT-79696
Release: 451-101-15.1-Clarity-Creator User License
Currently being reviewed