AnsweredAssumed Answered

NSQL Parameter results in no results inless a value in passed (filtered)

Question asked by marlon.mckenzie on Mar 21, 2011
Latest reply on Mar 22, 2011 by marlon.mckenzie
Hello,

Running to an issue on a portlet i've constructed. I have a filter that is based on the parameter below that I plan on using to filter my data. The only issue is that although this seems to be working, I only get results when I pass a value through that filter. So for instance, if I press "show all", I get nothing. I only get data when I filter my dataset by portfolio. Any ideas?


(P.ID IN (select prt.id
from pma_portfolios prt
start with prt.id = @WHERE:PARAM:USER_DEF:INTEGER:PortfolioID@
connect by prior prt.id = prt.parent_id))


Note: p.id is the id of the portfolio object instance.


Thanks,
Marlon

Outcomes