AnsweredAssumed Answered

Filter Lookup on Portlet

Question asked by Colum on May 14, 2014
Latest reply on May 15, 2014 by Colum

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.

SELECT

@SELECT:A.FULL_NAME:full_name@

FROM
(
SELECT DISTINCT
R.FULL_NAME
FROM INV_IDEAS I
INNER JOIN SRM_RESOURCES R
ON( I.INITIATOR_ID = R.USER_ID)
) A

WHERE @FILTER@

Outcomes