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

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
from pma_portfolios prt
start with = @WHERE:PARAM:USER_DEF:INTEGER:PortfolioID@
connect by prior = prt.parent_id))

Note: is the id of the portfolio object instance.