I have a query based grid portlet. The data provider is a database view created specifically for the portlet. The portlet primarily provides information on Ideas and Idea custom sub-objects. One of the fields returned is the Requestor name. The field returned is SRM.RESOURCES.FULL_NAME such as, SMITH, JOHN. I created a custom lookup to use on the filter field so people could do a multi-select but I get an "Error 500 - Internal Server Error" when I try to use the filter. Any idea what the issue is?
This is my custom lookup. I joined INV_IDEAS and SRM_RESOURCES so it returns only people who requested an Idea. Filed datatype is text so lookup values match data returned in portlet.
FROM INV_IDEAS I
INNER JOIN SRM_RESOURCES R
ON( I.INITIATOR_ID = R.USER_ID)