The Resource Finder portlet stops working when a Multi-Value Lookup is added to the list view. Once the field is added the portlet shows "There are no items to display" even is Show All is clicked.
STEPS TO REPRODUCE:
Expected Results: Data to be displayed along with the MVL lookup
Actual Results: Portlet shows: There are no items to display
This same behavior is also reproducible on the Project > Team tab if you use the Resource Finder magnifying glass
This is caused by DE28376/CLRT-74058
After a careful review to the affected area it was decided the defect will not be fixed due to its complexity
Workaround: Do not add Multi-Value lookup fields to the resource Finder portlet list view. If added, please remove it so the portlet works fine again
app-ca.log file shows the following error:
ERROR 2021-11-24 23:37:19,995 [http-nio-1593-exec-353] niku.union (clarity:admin:5588095__77A797B4-1F47-4CB8-97CF-750EBC6DBD9A:resource.resourceFinderSearch) Unable retrieve resource finder list com.niku.union.persistence.PersistenceException: SQL error code: 904 Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00904: "SRM_RESOURCES"."MVL": invalid identifier