Skip to Content
0
Former Member
Mar 04, 2009 at 05:29 PM

Hierarchy restriction problem with multi provider query

29 Views

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