hi,
i have multiprovider query. which has one prequery.
i have restricted personal area hierarchy nodes in prequery. the prequery is been used in main query
but when i execute the query i still see those restricted nodes values there in output.
if i restrict same nodes in main query - it works. but not with prequery. My query runs for data range between 2007 and 2009. that calendar year range i have put in prequery.
if the same query i run for years 2008 and 2009 range data in prequery - it works fine with hierarchy restriction.
also, its not pulling right data for one the required node also.
how do i resolve this ?
thanks,
KS