Skip to Content
0
Former Member
Jul 18, 2009 at 03:43 PM

Sub query in BOXI R2 filter condition

25 Views

Hi Experts,

Can we use subqueries to calculate the filter values.

eg;

I will be passing a prompt(say worker_id) to a report. Based on that worker id, a subquery will be executed which will fetch certain results.

Then I will have a filter(say XYZ) to filter the values based on the result of the subquery.

It will look like:

Prompt: 
Enter worker_id : 123 

Sub query: 
Select worker_id from abd 
start with worker_id = @Prompt Value 
Connect by prior worker_id = supervisor_id 

Filter: 
XYZ In List (Sub Query Values)

Please help.

Thanks,