Navigate between Requests based on UNION's... not working correctly
633313Jun 2 2009 — edited Aug 17 2011Interesting problem with UNION type requests and navigating between them...wonder if this is a bug or just me doing something wrong...
I've created a request based on a union of two requests (combine with similar requests) and then "Navigate" to a second request (that is also a union of two requests). My second request has a column that "is prompted" based on the value passed from the first request (drill-down effect). But then I noticed that the prompted value is not passed to the WHERE clause of my second request. My second request are being displayed, the filter is just not applied correctly.
I played around a bit and noticed the following behavior:
a) UNION request Navigate to UNION request - does not work (my first example above)
b) Single request Navigate to UNION request passes values correctly
c) UNION request Navigate to Single request - does not work
d) Single request navigate to Single request works (obviously...)
Has anybody seen this behavior (or managed to be able to navigate between requests that are UNION's)?