I have parent and a child portlet. parent is drilled down to child when i click on a column in parent.
My requirement is to have filters in child as well.User should be able to filter child portlet individually and also after drilled down from parent.
Scenario 1: I Clicked on a column in parent and drilled down to child(it has few records).Now again I want to filter child portlet with new filters excluding parent filters i.e like a normal Grid portlet.
Scenario 2: I go to the child portlet directly and should be able to filter.
When i go to the child portlet i see that the link parameter value in the URL is not null but appended with parameter source ID (portlet page link param).The URL appears to be as follows:
I am supposed to handle these two scenarios in the child portlet.
Child query is attached,
this is the code snippet where i'm handling the above 2 scenarios,but unable to filter the data :(
AND ((POUF.BRANCH_UNIT_ID=@where:param:xml:integer:/data/obs/@value@) --param obs is mandatory,passed from parent
OR (@WHERE:PARAM:USER_DEF:INTEGER:branch_unit_id@ is not null
Thanks in advance,