Can we use subqueries to calculate the filter values.
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)