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 fp.id id,
from fin_plans fp
WHERE @where:PARAM:XML:INTEGER:/data/odf_pk/@value@ = x.object_id