vivek.gupta4

Filter Portlet fields

Discussion created by vivek.gupta4 on Sep 16, 2010
Latest reply on Sep 17, 2010 by Chris_Hackett
Hi All,

Our customer wants to have a portlet which should have a filter field showing names of all portlets in the system. On selecting a portlet name in the filter field, all the filter fields of that portlet should be listed below. I have achieved this functionality for all portlets except for 'filter portlets' using query:

SELECT A.ATTRIBUTE_CODE COLUMN_CODE, A.LABEL COLUMN_LABEL, P.PORTLET_CODE
FROM ODF_VIEW_ATTRIBUTES A, ODF_VIEWS V, CMN_PORTLETS P
WHERE V.VIEW_TYPE='filter'
AND A.VIEW_ID=V.ID
AND V.OBJECT_CODE = TO_CHAR(P.ID)
AND PORTLET_CODE=@WHERE:PARAM:USER_DEF:STRING:PORTLET_CODE@

Can someone tell me how to find out the filter fields for filter portlets.

Regards,
Vivek

Outcomes