AnsweredAssumed Answered

Portlet: filter based on dynamic lookup with parameter investment-id

Question asked by Rnitram on May 9, 2014
Latest reply on Jul 24, 2014 by pirsop

Hello, I wonder if anyone can help me on this. I want to display a list of all cost plans for the current project in a filter field populated by the lookup query below. However, this works only when linked to a project-object attribute, but not in the filter field of the portlet. If this is not at all possible, then I would like to know if I could display to portlets on the same tab to the user and let him select the "filter" fields in the first portlet used in the second portlet below. Unfortunately the term @where:PARAM:XML:INTEGER:/data/id/@value@ does not retrieve the project-id from the url as it does with any other paramter passed there...

SELECT  @SELECT:X.id:Plan_ID@,
        @SELECT:X.object_id:Object_ID@,
 @SELECT:X.name:Plan_Name@,
 @SELECT:X.PLAN_TYPE_CODE:PLAN_TYPE_CODE@,
 @SELECT:X.IS_PLAN_OF_RECORD:IS_PLAN_OF_RECORD@

  FROM
(select fp.id id,
fp.object_id object_id,
fp.name name,
fp.plan_type_code plan_type_code,
fp.is_plan_of_record is_plan_of_record
from fin_plans fp
) X
WHERE @where:PARAM:XML:INTEGER:/data/odf_pk/@value@ = x.object_id
AND @FILTER@

 

Outcomes